Specifications

Using the SQL Server Utility Dashboard CHAPTER 5 93
■
Data-Tier Application Health This section is located in the top-right corner of the
Utility Explorer Content pane. Health status is illustrated in a pie chart and has four
possible designations:
●
Well Utilized The number of deployed data-tier applications that are not violat-
ing resource utilization policies is displayed.
●
Overutilized The number of deployed data-tier applications that are violating
resource overutilization policies is displayed. A deployed data-tier application is
marked as overutilized if any of the following conditions are true:
■
CPU resources for the deployed data-tier application are overutilized.
■
CPU resources of the computer that hosts the SQL Server instance are
overutilized.
■
Storage volumes associated with the deployed data-tier application are
overutilized.
■
The deployed data-tier application contains data or log les that reside on volumes
with overutilized storage space.
●
Underutilized The number of deployed data-tier applications that are violating
resource underutilization policies is displayed. A deployed data-tier application is
marked as underutilized if any of the following conditions are true:
■
CPU resources for the deployed data-tier application are underutilized.
■
CPU resources of the computer that hosts the SQL Server instance are
underutilized.
■
Storage volumes associated with the deployed data-tier application are
underutilized.
■
The deployed data-tier application contains data or log les that reside on
volumes with underutilized storage space.
●
No Data Available Either data afliated with deployed data-tier applications has
not been uploaded to the Utility Control Point or there is a problem with the collec-
tion and upload process.
By viewing the Data-Tier Application Health section, DBAs can quickly obtain a holistic
view of resource utilization for all deployed data-tier applications managed by the SQL
Server Utility. In Figure 5-6, there are seven well-utilized and two overutilized data-tier
applications.
■
Data-Tier Applications With Overutilized Resources This section is found
directly under the Data-Tier Application Health section. It displays overutilization data
for deployed data-tier applications based on the following categories:
●
Overutilized Data-Tier Application CPU This represents the number of
deployed data-tier applications that are violating data-tier application CPU
overutilization policies.