O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required