Metric | Why it is important |
|---|
I/O | Indicates the amount of input and output occurring on your SQL Server instance. A consistently high rate may indicate a higher risk of performance issues as the SQL Server processes wait for I/O to become available. |
Locks | Indicates the wait time caused by locks on databases hosted by this SQL Server instance. |
Log | Indicates the wait time related to database transaction logs. |
Memory | Indicates all wait time related to memory operations. |
Signal | Indicates that a SQL Server process is waiting for CPU time after the associated resources became available for processing. |
Other | Indicates all lock waits not included in other categories and not excluded from monitoring. |