You’re experiencing a sudden slow down in SQL Server performance. Users are complaining. Many reasons could be causing this sudden slowdown.
For SQL Server performance problems, gathering and analyzing data is not enough. A lot of time can be wasted analyzing data not relevant to the problem.
Before you contact me to report a problem, spend some time preparing the information to assist in solving the problem. This assists me to work with you quicker in solving the SQL Server performance issue.
Some suggestions to solve the problem faster are:
Focus on these questions:
Once you’ve completed the above steps, contact me to work with you directly. The normal procedure is I will send you some data gathering scripts about database server information and database usage. The nature of the scripts is based on the information you send me.
Republished from http://www.sqlserver-dba.com.