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 a benchmarking framework on multiple instances


Benchmarking a platform is highly essential in order to keep up the Service Level Agreements (SLA) for your application and database environment. Also, the task will enable the service orientation behavior as a proactive manner that will avoid any unprecedented activity on the data platform.

The key result out of benchmarking is to find the problem with a consistent view of services, and familiarize with application operational behavior to streamline any issues that are persistent, not to mention about performance monitoring and troubleshooting. There are no technical details on how to implement this, but in this recipe we will go through a tool that will help in implementing a benchmarking framework on multiple instances of the data platform.

Note

TPC stands for Transaction Processing Council, which is a non-profit corporation founded to define transaction processing and database benchmarks to disseminate objective, verifiable TPC...