Microsoft SQL Server 2008 R2 Administration Cookbook

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