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

Introduction


Maintenance and Monitoring are essential parts of database administration and any relational database has no exclusion from these tasks. There are various tools available from the SQL Server product in addition to the tools from the Windows operating system. The key aspects of SQL Server maintenance is to keep up the availability and achieve optimal performance, thereby minimizing the time for users to obtain the results of queries and provide out of the box scalability. In order to reduce manual intervention, monitoring will help us to track the resource usage, network traffic, and transactions usage on the data platform. For a DBA to improve the system performance, it is essential to line-up baseline and benchmarking of the data platform.

Note

Baseline: It is a series of measurements taken when a system is newly configured or an existing system has been extensively reconfigured.

Benchmarking: It is an inclusive report of system performance that is captured at multiple times and...