I am recently working on upgrading my class Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning with additional details and more interesting examples. While working on slide deck I realized that I need to have one solid slide which talks about checklist for analyzing slow running queries. A quick search on my saved book mark link come up with interesting book online link. This link very clearly suggests: To save time, consult this checklist before you contact your technical support provider.I strongly suggest you to do the same, first consult this checklist and if you still further need help, leave comment here.
Checklist for Analyzing Slow-Running QueriesThere are a number of common reasons for slow-running queries and updates: * Slow network communication.
* Inadequate memory in the server computer, or not enough memory available for SQL Server.
* Lack of useful statistics
* Lack of useful indexes.
* Lack of useful indexed views.
* Lack of useful data striping.
* Lack of useful partitioning.Read more: Journey to SQL Authority with Pinal Dave
Checklist for Analyzing Slow-Running QueriesThere are a number of common reasons for slow-running queries and updates: * Slow network communication.
* Inadequate memory in the server computer, or not enough memory available for SQL Server.
* Lack of useful statistics
* Lack of useful indexes.
* Lack of useful indexed views.
* Lack of useful data striping.
* Lack of useful partitioning.Read more: Journey to SQL Authority with Pinal Dave