hi Fellas,
We have SQL Resource Governor setup on a a sql maintenance job which runs weekly once.
I see the below messages logged in errorlog almost daily.
Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID 118 for details. Classifier elapsed time: 1 ms.
Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID 128 for details. Classifier elapsed time: 0 ms.
In RG, the Grant timeout/sec value is set to 0.
Any advise why this is triggering almost daily?