Specifications

92 CHAPTER 5 Consolidation and Monitoring
●
No Data Available Either data has not been uploaded from a managed instance
or there is a problem with the collection and upload process.
By viewing the Managed Instance Health section, DBAs are able to quickly obtain an
overview of resource utilization across all managed instances within the utility. The
example in Figure 5-6 shows that ve managed instances are well utilized, six are over-
utilized, none are underutilized, and data is unavailable for three managed instances in
the Managed Instance Health section.
■
Managed Instances With Overutilized Resources This section is found directly
under the Managed Instance Health section. It displays overutilization data for man-
aged instances of SQL Server based on the following categories:
●
Overutilized Instance CPU This represents the number of managed instances
of SQL Server that are violating instance CPU overutilization policies.
●
Overutilized Database Files This represents the number of managed instances
of SQL Server with database les that are violating le space overutilization policies.
●
Overutilized Storage Volumes This represents the number of managed in-
stances of SQL Server with database les on storage volumes that are violating le
space overutilization policies.
●
Overutilized Computer CPU This represents the number of managed instances
of SQL Server running on computers that are violating computer CPU overutiliza-
tion policies.
Detailed status for each health parameter is listed in a sliding indicator to the right of
each element in this section.
■
Managed Instances With Underutilized Resources This section is located under
the Managed Instances With Overutilized Resources section and displays underutiliza-
tion data for managed instances of SQL Server based on the following categories:
●
Underutilized Instance CPU This represents the number of managed instances
of SQL Server that are violating instance CPU underutilization policies.
●
Underutilized Database Files This represents the number of managed instances
of SQL Server with database les that are violating volume space underutilization
policies.
●
Underutilized Storage Volumes This represents the number of managed
instances of SQL Server with database les on storage volumes that are violating le
space underutilization policies.
●
Underutilized Computer CPU This represents the number of managed instanc-
es of SQL Server running on computers that are violating computer CPU underuti-
lization policies.
Detailed status for each health parameter is listed in a sliding indicator to the right of
each element in this section.