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

Monitoring system health using system statistical functions

SQL Server has a set of few useful system statistical functions that provide certain statistics related to SQL Server health. These functions are useful for checking and monitoring the health of the server.

Suppose that, in your database environment, one of the web applications is processing records row-by-row. In order to process each row, the application makes a round trip to the database. This means that to process each row there is a new connection. In order to troubleshoot the issue, you want to monitor at regular intervals the number of connections that are taking place. This example will describe how to perform the said task.

Getting ready

In this recipe we will use following functions: ...

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