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.
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