O'Reilly logo

SQL Server DMVs in Action: Better Queries with Dynamic Management Views by Ian W. Stirk

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 9. Database-level DMVs

 

This chapter covers
  • Using tempdb to identify and fix space problems
  • Index operations to identify and improve SQL query performance

 

This chapter covers a miscellany of functionality that collectively belongs to the database DMVs. We’ll examine and discuss the importance of tempdb, how its space is used by different objects, how much space is used by individual sessions and running tasks, and why it’s important to monitor. If tempdb has problems, it can affect all the databases on SQL Server. Typically tempdb problems are reported in the SQL Server error log. We’ll examine how to check tempdb for potential problems and how to fix them, as we’ll look at a list of tempdb best practices.

We’ll investigate ...

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