SQLAuthority News – Download White Paper – Troubleshooting Performance Problems in SQL Server 2008

Troubleshooting Performance Problems in SQL Server 2008
SQL Server Technical Article
Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel
Technical Reviewers: Jerome Halmans, Fabricio Voznika, George Reynya
Published: March 2009

It’s not uncommon to experience the occasional slowdown of a database running the Microsoft SQL Server database software. The reasons can range from a poorly designed database to a system that is improperly configured for the workload. As an administrator, you want to proactively prevent or minimize problems; if they occur, you want to diagnose the cause and take corrective actions to fix the problem whenever possible. This white 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 (in the Windows Server 2003 operating system) or Performance Monitor (in the Windows Vista operating system and Windows Server 2008), also known as Perfmon
  • Dynamic management views (sometimes referred to as DMVs)
  • SQL Server Extended Events (Extended Events) and the data collector, which are new in SQL Server 2008.

Download “Troubleshooting Performance Problems in SQL Server 2008” from the Microsoft Download Center.

Abstract courtesy : Microsoft

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Documentation, SQL Download, SQL White Papers
Previous Post
SQL SERVER – Find Statistics Update Date – Update Statistics
Next Post
SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010

Related Posts

3 Comments. Leave new

  • When I import image field (long binary data) from ms access to ms sql server 2008 (image/var binary/binary)….color images are not comming;only b&W images are importing…color images rows are comming blank..
    plz help to solve this.

  • Hi Pinal
    Thanks for the article

    I’m asked questions like this in many interviews, how to trouble shoot sql server performance problem or how to trouble shoot stored procedure performance problem.

    It would be very nice if you write one about this in short(not that much wide in the document specified in this article). If you already written please specify here

    Come on! keep writing, we shall keep learning !


  • Really helpfu!


Leave a Reply