SQL Server Performance Tuning - Approaches for tuning Queries

By Santhosh N

This explains how to approach and check for bottlenecks in the SQL queries.

Most of the times, server components are the ones which anyone lookout when we feel Database server is slow in responding to the queries. But, it’s equally important to check for the Queries that perform slow and fine tune them for better performance. The following are major things which you need to be checking for slow running queries both from Server perspective along with queries.

1) The network communication might be slow to begin with which might be a factor.
2) The allocated memory for the processing of the Microsoft SQL Server might be low.
3) Lack of the useful statistics collected on the server to monitor the query performance
4) The statistics collected might be out dated
5) Indexes might not be created for proper column(s) in the table as per the latest statistics
6) Lack of useful data striping might also cause for slow query performance.

Related FAQs

This explains the various precautions needs to be taken care while indexing and choosing what columns needs to be indexed for better performance.
This explains about using functions with Indexed columns in Sql query
This explains the performance overhead of using NULL values in the columns of the Database table.
This describes the usage of DBCC SHOW_STATISTICS command which is used for performance tuning in the Sql Server.
This explains how to create secondary XML indexes and different types of Secondary indexes that can be created for XML Data types in SQL Server
This explains about the limitations of the XML Data type in Sql Server in terms of creating Index
SQL Server Performance Tuning - Approaches for tuning Queries  (1114 Views)