SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Performance Tuning - optimizing for response time

Different  queries are optimized for different objectives

Response Times and Throughput are two standard objectives.

Response Time is about retrieving the  hits as quickly as possible. In a search engine , that would mean returning the first few rows immediately

Throughput is about returning ALL the hits (rows) in the smallest time frame

Factors to consider in improving Response Time

1)       Parallelism

2)       Partitioning

3)       Data types – such as CLOBs in the table

4)       Sorting

5)       Memory

6)       SQL Statistics

See Also

Waitstats CXPACKET wait type and how to reduce it

SQL Server Performance ,memory pressure and memory usage

SQL Server Buffer Cache Hit Ratio and memory pressure

Author: Jack Vamvas (http://www.sqlserver-dba.com)


Leave a comment on the original post [www.sqlserver-dba.com, opens in a new window]

Loading comments...