Dec 20, 2014

Common causes database performance bottleneck in SQL SERVER

An interesting survey

There are many survey has been conducted regarding the causes of SQL server performance bottlenecks which they found   while tuning the queries in a database. Below table illustrates the aggregates:

Root Cause
Response (%)
Database Design
Query Writing
Index and Statistics Strategy
Application Code
Server Configuration and Settings

If we will observe the responses, application code and query writing is almost 50% responsible for degradation of database performance!! Here we will discuss about all the root causes of query bottleneck in detail.

No comments: