When I run this query, I see high wait time for
SELECT * FROM sys.dm_os_wait_stats WHERE wait_type IN ( 'CLR_AUTO_EVENT', 'CLR_CRST', 'CLR_JOIN', 'CLR_MANUAL_EVENT', 'CLR_MEMORY_SPY', 'CLR_MONITOR', 'CLR_RWLOCK_READER', 'CLR_RWLOCK_WRITER', 'CLR_SEMAPHORE', 'CLR_TASK_START', 'CLRHOST_STATE_ACCESS', 'ASSEMBLY_LOAD', 'FS_GARBAGE_COLLECTOR_SHUTDOWN', 'SQLCLR_APPDOMAIN', 'SQLCLR_ASSEMBLY', 'SQLCLR_DEADLOCK_DETECTION', 'SQLCLR_QUANTUM_PUNISHMENT' ) ORDER BY wait_time_ms DESC, wait_type ASC;
In a related question What is the SQLCLR wait type in Activity Monitor within SQL Server Management Studio (SSMS)? , I read that it appears when running .NET managed code within SQL Server.
However, I don't think I'm using any of that. When I execute
EXEC sp_configure 'clr enabled', I see:
It looks to me like it's not even enabled. Can anybody please explain what's going on?
PS: I'm running SQL Server 2017 Developer Edition (14.0.3026.27).