Database Reference
In-Depth Information
Troubleshooting resource health issues identified by an SQL Server UCP might include mitigating
over-utilized CPU on a computer on an instance of SQL Server, or mitigating over-utilized CPU for
a data-tier application. Other issues might include resolving over-utilized file space for database
files or resolving over-utilization of allocated disk space on a storage volume. The managed
instances health parameter collects the following system resource information:
F
CPU utilization for the instance of SQL Server
F
Database files utilization
F
Storage volume space utilization
F
CPU utilization for the computer
Status for each parameter is divided into four categories:
F
Well-utilized: Number of managed instances of an SQL Server, which are not
violating resource utilization policies.
F
Under-utilized: Number of managed resources, which are violating resource under-
utilization policies.
F
Over-utilized: Number of managed resources, which are violating resource over-
utilization policies.
F
No Data Available: Data is not available for managed instances of SQL Server as
either the instance of SQL Server has just been enrolled and the first data collection
operation is not completed, or because there is a problem with the managed instance
of SQL Server collecting and uploading data to the UCP.
The data collection process begins immediately, but it can take up to 30 minutes for data
to appear in the dashboard and viewpoints in the Utility Explorer content pane. However,
the data collection set for each managed instance of an SQL Server will send relevant
configuration and performance data to the UCP every 15 minutes.
Search WWH ::
Custom Search