A new great whitepaper to bookmark amongst your favourites:
Troubleshooting Performance Problems in SQL Server 2008
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 -