O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

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

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