Troubleshooting Performance Problems in SQL Server 2008

Troubleshooting Performance Problems in SQL Server 2008 Whitepaper

This SQL Server white paper gives you step-by-step guidelines for diagnosing and troubleshooting common performance problems by using the following tools:

▪ SQL Server Profiler
▪ System Monitor (in the Windows Server 2003 operating system) or
▪ Performance Monitor (in Windows Vista operating system and Windows Server 2008), known as Perfmon
▪ Dynamic management views (referred to as DMVs)
▪ SQL Server Extended Events (Extended Events) and the data collector, which are new in SQL Server 2008.