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 3. System Statistical Functions, Stored Procedures, and the DBCC SQLPERF Command

In this chapter we will cover:

  • Monitoring system health using system statistical functions
  • Monitoring SQL Server processes and sessions with system stored procedures
  • Monitoring log space usage statistics with the DBCC SQLPERF command

Introduction

There are a few system statistical functions, stored procedures, and DBCC commands that can be useful while analysing performance-related issues. However, even though most of the statistical information that these commands provide can be retrieved by using dynamic management views and dynamic management functions, many database professionals use these features because they have been a part of SQL Server for a long time ...

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