SQL Server 2008's Dynamic Duo: Management Views and Functions

Overview

The dynamic management views and functions, which were introduced in SQL 2005, have increased in number and provide improved function in SQL 2008. Taking advantage of these new objects gives you quick and easy access to in-depth information on nearly every aspect of SQL's internal workings. Their uses include, at a minimum, getting performance data, index usage statistics, and object dependency information. This white paper will explore a few of their capabilities and give examples to show how they can ease the workload of a database administrator. They are well worth the investment in time and effort.