CLR_TASK_START

Description

This wait accumulates during CLR task startup. This is an expected wait and minimal values are acceptable. If values are excessive see suggested solutions below

DBAs and Developers

Suggested solutions

  1. Ensure CLR code is written as per best practices (link below)
  2. Run an Extended Event collecting wait statistics. Find which requests are accumulating the wait type and rectify

Additional research

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

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