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
10
Query Writing
30
Index and Statistics Strategy
22
Application Code
18
Server Configuration and Settings
20

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:

Post a Comment