Troubleshooting Performance Problems in SQL Server 2008


A new great whitepaper to bookmark amongst your favourites:


 


Troubleshooting Performance Problems in SQL Server 2008


http://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 -

Comments (0)

Skip to main content