Description
This wait accumulates while SQL Server is waiting for the operating system to perform CLR operations. This wait type is not documented by Microsoft so not much is known about it. This wait type does not charge as part of regular CLR execution. 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 and Developers
Suggested solutions
- Ensure CLR code is written as per best practices (link below)
- Run an Extended Event collecting wait statistics. Find which requests are accumulating the wait type and rectify
Additional research
PREEMPTIVE and Non-PREEMPTIVE
Common Language Runtime from the DBA Point of View
SQLCLR: A DBA’s friend or foe?
The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment