Troubleshoot SQL Server Resource Health (SQL Server Utility)
Applies To: SQL Server 2016
Troubleshooting resource health issues identified by a SQL Server UCP might include mitigating overutilized CPU on a computer or on an instance of SQL Server, or mitigating overutilized CPU for a data-tier application. Other issues might include resolving overutilized file space for database files or resolving overutilization of allocated disk space on a storage volume.
Note that if a database is in “emergency” state, the health state will display overutilized log file space.
For more information about failed data collection resulting in gray status icons in the managed instance list view on a UCP, see Troubleshoot the SQL Server Utility. For more information about getting started with SQL Server Utility, see SQL Server Utility Features and Tasks.
For more information about mitigating specific resource health issues identified by a SQL Server UCP, see the following topics: