Specifications

Using the SQL Server Utility Dashboard CHAPTER 5 91
The SQL Server Utility dashboard includes the following information:
■
Utility Summary Found in the center of the top row of the Utility Explorer Content
pane, this section is the rst place to look. It displays the number of managed instances
of SQL Server and the number of deployed data-tier applications managed by the SQL
Server Utility. Use the Utility Summary section to gain quick insight into the number of
objects being managed by the SQL Server Utility. In Figure 5-6, there are 14 managed in-
stances and nine deployed data-tier applications displayed in the Utility Summary section.
NOTE After you have reviewed the summary information, it is recommended that
you analyze either the managed instances or deployed data-tier application section
in its entirety to gain a comprehensive understanding of its overall health status. For
example, the rst set of the following bullets interpret the health of managed instances.
After managed instances are analyzed and explained, then the health of data-tier
applications is reviewed from beginning to end.
■
Managed Instance Health This section is located in the top-left corner of the Util-
ity Explorer Content pane and summarizes the health status of all managed instances
of SQL Server in the SQL Server Utility. Health status is illustrated in a pie chart and has
four possible designations:
●
Well Utilized The number of managed instances of SQL Server that are not vio-
lating resource utilization policies is displayed.
●
Overutilized A SQL Server instance is marked as overutilized if any of the follow-
ing conditions are true:
■
CPU resources for the instance of SQL Server are overutilized.
■
CPU resources of the computer that hosts the SQL Server instance are
overutilized.
■
The instance contains data or log les with overutilized storage space.
■
The instance contains data or log les that reside on volumes with overutilized
storage space.
●
Underutilized A SQL Server instance is marked as underutilized if it is not
marked as overutilized and any of the following conditions are true:
■
CPU resources allocated to the instance of SQL Server are underutilized.
■
CPU resources of the computer that hosts the SQL Server instance are
underutilized.
■
The instance contains data or log les with underutilized storage space.
■
The instance contains data or log les that reside on volumes with underutilized
storage space.