Troubleshooting Performance Problems in SQL Server 2005

By Bill Graziano on 3 November 2005 | Tags: Administration


It is not uncommon to experience the occasional slow down of a SQL Server database. A poorly designed database or a system that is improperly configured for the workload are but several of many possible causes of this type of performance problem. Administrators need to proactively prevent or minimize problems and, when they occur, diagnose the cause and take corrective actions to fix the problem. This paper 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. Note: This links directly to the Word document.

Link: Troubleshooting Performance Problems in SQL Server 2005


Related Articles

Advanced SQL Server 2008 Extended Events with Examples (25 May 2009)

Introduction to SQL Server 2008 Extended Events (19 May 2009)

Monitoring SQL Server Agent with Powershell (24 March 2009)

SQL Server Version (29 January 2009)

Scheduling Jobs in SQL Server Express - Part 2 (1 December 2008)

Alerts for when Login Failures Strike (14 July 2008)

Using xp_ReadErrorLog in SQL Server 2005 (12 May 2008)

Moving the tempdb database (5 November 2007)

Other Recent Forum Posts

SQL Server 2012 - how to get the latest entries from a column on a table? (2h)

[SQL] Who spent most money (22h)

Use SUM() function in a multiple tables relationship (2d)

To get Month year in select Query (2d)

How to print part of the alert message (3d)

Specific condition after 'THEN' in a Case Statement Table Update (3d)

SQL Beginner - Assistance with Multiple Column assigned to Variable Based on Column Value & Multiple Case Instances (4d)

Need help with this query (4d)

- Advertisement -