Chapter 30. Dynamic management objects

After completing this chapter, you will be able to

  • Use dynamic management objects to gain insights into SQL Server.

  • Query valuable passively collected server-performance statistics.

  • Query valuable passively collected indexing statistics.

Entire books have been written on the subject of dynamic management objects (DMOs). Large wall-posters are available at your local SQL Server User Group detailing each DMO in small font sizes. With each version of Microsoft SQL Server since 2005, more and more information has become available in the massive collection of passive SQL Server statistics, accessible via dynamic management views (DMVs) and dynamic management functions (DMFs). This data is passively collected by SQL ...

Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.