-
제목
What does "Other Waits" mean in SQL PI? -
설명
What does "Other Wait" mean in SQL Server PI?
-
원인
Other wait indicates miscellaneous instance waits consisting of infrequent or otherwise special purpose wait states that should, in most cases, be very close to 0. Although this deviation does not necessarily indicate a performance problem, the performance history should be reviewed. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.
-
해결 방안
In SQL Server PI, the Other Waits category is broken down into sub-categories to provide further information (as are all resource event categories).
Other Wait sub-categories include: Backup/Recovery Wait, Cursor Synchronization Wait (previously a dedicated category), Database Replication Wait, Deferred Task Worker Wait, External Procedure Wait, Full Text Search Wait, Hosted Component Wait, Other Miscellaneous Wait (this will aggregate the generally negligible events), Parallel Coordination Wait (previously a dedicated category), Service Broker Wait, and Synchronous Task Wait. Clicking the resource breakdown pie chart in the GUI will provide a full breakout of the individual wait events observed.