The ID of the classifier function that is currently used by Resource Governor. Returns a value of 0 if no function is being used. Is not nullable.

Note

This function is used to classify new requests and uses rules to route these requests to the appropriate workload group. For more information, see Resource Governor.

is_reconfiguration_pending

bit

Indicates whether or not changes to a group or pool were made with the ALTER RESOURCE GOVERNOR RECONFIGURE statement but have not been applied to the in-memory configuration. The value returned is one of:

0 - A reconfiguration statement is not required.

1 - A reconfiguration statement or server restart is required in order for pending configuration changes to be applied.