-
Book Overview & Buying
-
Table Of Contents
Microsoft SQL Server 2008 R2 Administration Cookbook
By :
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
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...
Change the font size
Change margin width
Change background colour