Specifications

22 CHAPTER 2 Multi-Server Administration
SQL Server Utility. It forms a collection of managed instances with a repository for perfor-
mance data and management policies. After data is collected from managed instances, Utility
Explorer and SQL Server Utility dashboard and viewpoints in SQL Server Management Studio
(SSMS) provide administrators with a view of SQL Server resource health through policy
evaluation and analysis of trending instances and applications throughout the enterprise.
The following entities can be viewed in the SQL Server Utility:
■
Instances of SQL Server
■
Data-tier applications
■
Database les
■
Volumes
Figure 2-1 shows one possible conguration using the SQL Server Utility, which includes a
UCP, many managed instances, and a workstation running SSMS for managing the utility and
viewing the dashboard and viewpoints. The UCP stores conguration and collection informa-
tion in both the UMDW and msdb databases.
SQL Server
Management Studio
Upload collection
data set
Managed instance
Managed instance
Utility Control Point
UMDW msdb
Upload collection
data set
Upload collection
data set
Managed instance
FIGURE 2-1 A SQL Server Utility Control Point (UCP) and managed instances