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.
If you are new to SQL Server and preparing for SQL Server Interview Q & A, I suggest to refer this SQL Interview Q & A as good start.
Reference : Pinal Dave (http://blog.SQLAuthority.com)