Understanding the operation of an application and tuning performance usually requires insights into the internal operation of the database engine components. While this was generally possible in earlier versions of SQL Server, SQL Server 2005 dramatically simplifies the process of surfacing this information with the introduction of dynamic management views and functions.

In this chapter, we described the new DMV functionality and took a detailed look at each of the new DMVs. We also covered several example scenarios where DMVs were used very effectively to investigate application performance and understand the workings of the database engine. Lastly, we stepped through the process of creating a sample performance data warehouse to archive ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.