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
About the Author
About the Reviewers
More DBA Manageability Best Practices

Implementing Central Management feature enhancements

Central Management Server (CMS) is a feature that enables the DBA to administer multiple servers by designating a set of server groups, which maintain the connection information for one or more instances of SQL Server. In this recipe, we will go through the implementation strategy for the CMS feature in your SQL Server data platform. Before we continue into the recipe, it is essential for you to understand the core functionality of this feature, which uses the multiple features from the SQL Server core database engine:

  • SQL Server system repository

  • Manage the SQL Server farm from one location

  • Easy reporting about system state, configuration, and performance

Getting ready

As per the feature characteristics described previously, there are three important components in the system. These components are:

  • Storage

  • Execution

  • Reporting

Storage is used to store the system repository, Execution manages the SQL Server instances, and Reporting shows the statistical...