Chapter 7. Dynamic Management Views and Dynamic Management Functions
In this chapter we will cover:
- Monitoring current query execution statistics
- Monitoring index performance
- Monitoring performance of TempDB database
- Monitoring disk I/O statistics
Introduction
With the inception of SQL Server 2005, Microsoft has introduced a very helpful feature in SQL Server known as Dynamic Management Views(DMV) and Dynamic Management Functions(DMF). These views and functions are used to retrieve internal statistics of an SQL Server instance for performance monitoring. They provide real-time statistics about a variety of the internal working details of the SQL Server that can be used for performance analysis to identify performance bottlenecks and hardware bottlenecks, ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook 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.
