Specifications

24 CHAPTER 2 Multi-Server Administration
■
The Utility Explorer user interface A component of SSMS, this interface provides
a hierarchical tree view for managing and controlling the SQL Server Utility. Its uses
include connecting to a utility, creating a UCP, enrolling instances, deploying data-tier
applications, and viewing utilization reports afliated with managed instances and
data-tier applications. You launch Utility Explorer from SSMS by selecting View and
then choosing Utility Explorer.
■
The Utility Explorer dashboard and list views These provide a summary and
detailed presentations of resource health and conguration details for managed
instances of SQL Server, deployed data-tier applications, and host resources such as
CPU utilization, le space utilization, and volume space utilization. This allows superior
insight into resource utilization and policy violations and helps identify consolidation
opportunities, maximizes the value of hardware investments, and maintains healthy
systems. The utility dashboard is depicted in Figure 2-2.
FIGURE 2-2 The SQL Server Utility dashboard