| title | Troubleshoot SQL Server Resource Health (SQL Server Utility) | Microsoft Docs |
|---|---|
| description | Learn about troubleshooting resource health issues that a SQL Server UCP identifies, such as overutilized CPU, file space, or allocated disk space. |
| ms.custom | |
| ms.date | 03/14/2017 |
| ms.prod | sql |
| ms.prod_service | database-engine |
| ms.reviewer | |
| ms.technology | configuration |
| ms.topic | conceptual |
| ms.assetid | 614f07b5-f221-4013-9f8d-22964cf42270 |
| author | MikeRayMSFT |
| ms.author | mikeray |
[!INCLUDE SQL Server] Troubleshooting resource health issues identified by a [!INCLUDEssNoVersion] UCP might include mitigating overutilized CPU on a computer or on an instance of [!INCLUDEssNoVersion], 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 [!INCLUDEssNoVersion] Utility, see SQL Server Utility Features and Tasks.
For more information about mitigating specific resource health issues identified by a [!INCLUDEssNoVersion] UCP, see the following topics: