Database Reference
In-Depth Information
1.
If you click on the Create a Utility Control Point (UCP), it opens up the Getting
Started window that includes shortcuts to wizards that you can use to set up a UCP.
2.
This acts a single-point of server to manage other multiple servers in a
centralized manner.
3.
The primary step is to specify the SQL Server instance, which will be designated as a
control point—UCP to host the central management servers.
4.
Once the UCP is created, click on Enroll instances of SQL Server with a UCP
to enroll additional server instances that will enable us to monitor and manage
them efficiently.
5.
Specify the SQL Server instance that is to be designated as a UCP and that will host
the central system management data warehouse.
6.
This data warehouse will record all the instance's resource utilization and health
information. To set up the SQL Server Utility you need to:
Create a UCP from the SQL Server Utility
Enroll instances of SQL Server with the UCP
Define Global and Instance level policies, and manage and monitor
the instances
7.
By default, the UCP instance itself becomes a managed instance. Once the wizard
has successfully finished, the process will be directed to the Utility Explorer Content
page, as shown in the following screenshot:
Search WWH ::
Custom Search