Troubleshooting Performance Problems in SQL Server 2005

By Bill Graziano on 03 November 2005 | 0 Comments | 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. Follow the link to Troubleshooting Performance Problems in SQL Server 2005...

Discuss this article: 0 Comments so far. Print this Article. This page has been read 16,797 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email This • Subscribe to this feed • Kick it • Save to del.icio.us • View blog reactions

Using xp_ReadErrorLog in SQL Server 2005 (12 May 2008)

Moving the tempdb database (5 November 2007)

Centralized Asynchronous Auditing across Instances and Servers with Service Broker (20 August 2007)

Centralized Asynchronous Auditing with Service Broker (16 July 2007)

SQL Server 2005 Best Practices on TechNet (4 December 2006)

Scripting Database Objects using SMO (Updated) (29 November 2005)

Dynamic Management Views (30 October 2005)

Using SHERLOCK to Monitor Blocking (2 August 2005)