SQL 2008 Whitepapers

  • Article

All the whitepapers for Microsoft SQL Server 2008 are available at https://www.microsoft.com/sqlserver/2008/en/us/white-papers.aspx

My favorite of them all is

Troubleshooting Performance Problems in SQL Server 2008 Whitepaper

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

 

Happy reading and troubleshooting!