Database Reference
In-Depth Information
See Also
The advanced features of the Policy Based Framework are covered in the recipe
Implementing
Policy
-
based
management
features
in
Chapter
7
,
Implementing
new
Manageability
features
and
practices
.
Designing Multi-server management from
SQL Server 2008 R2
Taking advantage of the two new manageability features-
Policy
Based
Management
and
Data
Collector
of
SQL
Server
2008
which are independent of each other-the multi-server
management addresses problems by providing further solutions to the DBAs. The lack of
manageability tools to manage multiple instances by understanding resource utilization and
enhancing effective reporting tools is plugged in using multi-server management from SQL
Server 2008 R2.
This recipe is intended to design the multi-server management component using SQL
Server 2008 R2 for data-tier applications (DAC). By operating the SQL Server Management
Studio or Visual Studio with the help of Utility Explorer (UE), we can design the Multi-Server
Management (MSM) component. The MSM provides several ways to view summary and
detailed data about the health state of managed instances of SQL Server. An additional
capability of UE enables the interface to view and manage policy definitions that includes
objects, data, and policies managed by the SQL Server utility.
Getting ready
The new feature of SQL Server 2008 R2—Utility Control Point (UCP)—allows DBAs to enroll
the SQL Server instances across their Enterprise network into a centralized multi-server
management point. Once the instances are enrolled, the default capacity policies of utilization
across the instances or applications are set. It is essential to check that you are using an SQL
Server 2008 R2 instance to register the UCP to design the multi-server management feature.
Search WWH ::
Custom Search