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 (http://blog.SQLAuthority.com)

About these ads

3 thoughts on “SQLAuthority News – Download White Paper – Troubleshooting Performance Problems in SQL Server 2008

  1. 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.


  2. 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 !



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s