PREEMPTIVE_OS_CLUSTEROPS

Description

This wait accumulates while SQL Server is waiting for failover cluster operations to complete. This typically occurs during Availability Group operations such as failover, setting changes and modifying Group Listeners. Some values in this wait type are expected but if values are high see the suggested solutions below. Pre-emptive waits are different from regular (emptive) waits as their execution is controlled by an external processes such as the operating system

Resolved by

DBAs

Suggested solutions

  1. Check the SQL Server error log for more information
  2. Examine Windows Failover Clustering logs to determine the cause of listener status changes
  3. Examine wait statistics on the instance for other Availability Group issues. Investigate accordingly

Additional research

Availability Group Listeners, Client Connectivity, and Application Failover
PREEMPTIVE and Non-PREEMPTIVE
AlwaysOn Availability Groups Troubleshooting and Monitoring Guide

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index