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