Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

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 baseline practices are:

  • Using the SQL Server 2008 R2 instance with a database that will perform unit testing for a baseline.

  • Dynamic Management View (DMVs): These are pre-installed within the core database engine.

  • Data collector: It is an automated way...