Database Reference
In-Depth Information
Storage space utilization
F Storage volume information
This Utility architecture provides capabilities such as dashboard, viewpoints, and resource
utilization policies, which can be classified as utility administration. Using SQL Server 2008
R2 Enterprise Edition UCP tool, we can manage 25 instances.
In this recipe, we will look at how to enroll multiple SQL Server instances and create a central
dashboard view as a single-point troubleshooting tool.
Getting ready
Open up the SQL Server Management Studio (SSMS), next to Object Explorer, a new tab
Utility Explorer will appear. Similarly, the Utility Explorer can be presented by navigating
View—Utility Explorer option. On the right-hand side, towards Object Explorer Details, you will
see multiple options that comprise the utility configuration steps (see the next screenshot).
How to do it...
In order to begin enrolling multiple SQL Server instances and create a central dashboard view
as a single-point troubleshooting tool, you will need to complete the following steps:
 
Search WWH ::




Custom Search