Poor performance can often be a result of several contributing factors. Providing specific details about your environment and setup can be useful in diagnosing the issue. The following forms can be used help you identify possible areas of focus, allowing you to isolate and correct the performance problem. In addition, they can be used to provide Customer Support with the information necessary to effectively troubleshoot the issue.
  1. Configure the appropriate Performance Monitor counters on the affected server(s) and/or workstation(s) to log hardware resource usage [PDF version] [Word version].
  2. Complete the SQL Server Performance Troubleshooting Checklist:
    • Short Form [PDF version] [Word version]. This form provides is with a general view of your environment. Complete this form if any of the following conditions are met:
      • You have been worked with Customer Support on this issue previously and have already provided them with some information.
    • Long Form [PDF version] [Word version]. This form provides us with the most detailed view of your environment. Complete this form if any of the following conditions are met:
      • You have not worked with Customer Support on this issue before.
      • You are explicitly requested to do so by a Customer Support Analyst.
  3. Provide the file(s) to the Customer Support Analyst you have been working with, via email, fax, or FTP.