Server Virtualization Research Library

Dynamic management views and functions were extraordinary additions to SQL 2005, and they have only improved in function and increased in number in SQL 2008. A minimal list of their uses would include getting performance data, index usage statistics, and object dependency information. Even if you have experience with SQL Server, you may be unsure as to how to use these tools or, for that matter, what they can do. This white paper will explore a few of their capabilities and give examples as to how they can ease the workload of a database administrator.