SQL Server 2008 R2 Multi-server Administration – A First Look

Once you have created the UCP, you can start enrolling
instances of SQL Server you wish to monitor and manage. This is done in the Enroll
Instance Wizard
, launch it by expanding the Utility Explorer tree,
right-clicking on Managed Instances and selecting Enroll Instance.
You will see the Introduction screen (as in the below two screenshots)


This wizard is also a series of five steps that will collect
information regarding the SQL Server instance to be enrolled and register it with
the UCP. On the first screen (below) click Next to proceed with the

 Next, as in the UCP wizard, click on the Connect
button to bring up the Connect to Server dialog box (see below) where you
select the Instance to be added, and then click Next to proceed.

Next, either specify a Windows Domain Account or a SQL
Server Agent service account for the utility collection set. Microsoft
recommends using a Windows domain account. Even if a SQL Server Agent account
must be used, it should not be a built-in account such as LocalService,
NetworkService or LocalSystem, but a windows domain account. Click Next
to continue (see below)

The Instance Validation screen (see below) shown
above is similar to the one you see in the UCP creation wizard. Click Next
to proceed after confirming all Action Results are a Success.

The Summary shows the settings of the SQL Server
Instance to be added. When you click Next, you will come to the final
step of the wizard – Enrollment of SQL Server, showing the status of
actions taken to enroll the instance in the UCP. Once you confirm the Success
of  all actions, click Finish to close the wizard (see below two

In the Utility Explorer Content page, there are
several sections showing a graphical representation of the resources
utilization. The Utility Summary box shows how many instances are
managed. The Managed Instance Health and Data-tier Application Health
indicates the overall health of instances. The Managed Instance with
Overutilized Resources
shows how many instances have overutilized the
available resources. Likewise, the Managed Instance with Underutilized
shows how many instances are underutilizing the available
resources. A similar explanation holds for the Data-tier Application boxes on
the right. The two boxes in the bottom shows the utilization history of the
utility control point managed instance.

A breakdown of utilization of each resource by individual
managed instances is also available. In the Utility Explorer page, you
click on the Managed Instances node, and on the right-hand side, in the Utility
Explorer Content
Page select the individual instances and look through the
utilization of each resource in detail.


Leave a comment

Your email address will not be published.