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.
Microsoft SQL Server 2008 R2 Administration Cookbook
By :
Microsoft SQL Server 2008 R2 Administration Cookbook
By:
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
Free Chapter
Getting Started with SQL Server 2008 R2
Administrating the Core Database Engine
Managing the Core Database Engine
Administering Core Business Intelligence Services
Managing Core SQL Server 2008 R2 Technologies
Improving Availability and enhancing Programmability
Implementing New Manageability Features and Practices
Maintenance and Monitoring
Troubleshooting
Learning the Tricks of the Trade
More DBA Manageability Best Practices
Customer Reviews