O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

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

Dynamic Management Views

Dynamic management views (DMVs), which were introduced in SQL Server 2005, provide a simple means for assessing the state of your SQL Server instance. These views provide a lightweight means for gathering diagnostic information without the heavy burden of some of the more complicated diagnostic tools. The diagnostic tools, such as heavy Profiler traces, Performance Monitor, DBCC executions, and the Database Engine Tuning Advisor are still available, but oftentimes, the information returned from the DMVs is enough to determine what may be ailing a SQL Server instance.

An extensive number of DMVs are available in SQL Server 2014. Some DMVs are scoped at the server level, and others are scoped at the database level. They ...

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