Chapter 31. Dynamic Management Views

Analyzing and tuning database performance is more an art than a science. There can be many reasons why performance may be suboptimal—insufficient memory, incorrectly configured system parameters, disk bottlenecks, and poorly written queries being just a few of the more common causes. Understanding the operational details and the possible cause of the problem is often more difficult and time-consuming than actually taking the corrective actions. Anything that helps you get to the bottom of the problem quickly helps save time, effort, and cost. SQL Server 2005 introduces more than 80 new Dynamic Management ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.