Troubleshooting Performance Problems in SQL Server 2008

  • Article

A new great whitepaper to bookmark amongst your favourites:

 

Troubleshooting Performance Problems in SQL Server 2008

https://msdn.microsoft.com/en-us/library/dd672789.aspx

 

This documentation 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.

 

- Beatrice Nicolini -