Diagnostics and Analysis White Papers
Troubleshooting Performance Problems in SQL Server 2005
Overview Many customers can experience an occasional slow down of their SQL Server database. The reasons can range from a poorly designed database to a system that is improperly configured for the workload. As an administrator, one wants to proactively prevent or minimize problems and, when they occur, diagnose the cause and, when possible, take corrective actions to fix the problem. This white paper limits its scope to the problems commonly seen by Customer Support Services (CSS or PSS) at Microsoft Corporation since an exhaustive analysis of all possible problems is not feasible. It provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as SQL Server Profiler, System Monitor, and the new Dynamic Management Views in SQL Server 2005.
| Publisher | Microsoft | File Format | WORD |
|---|---|---|---|
| Date Published | October 2005 | Downloads | 22 |
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful?
White Paper RSS
Download
