grant timeout (sec) workload groups for resource pool

  • 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?

    Thanks.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply