O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

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

Implementing performance baseline practices

Let's see what practices we need to measure a performance baseline and how best we can implement them. These measurements must be taken during on-peak and off-peak hours on the data platform from a typical resource-intensive operation. All the subsequent measurements are compared with relevant baselines, and to determine the course of action we need to establish performance thresholds. These thresholds will help the DBAs to trigger fine tuning methods before a performance downtrend approaches. In this recipe, we will implement the performance baseline practices on the data platform that will help us to keep up the scalability and availability.

Getting ready

The essential tools to implement performance ...

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