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 Queries
There 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
Posts
