sp_configure, Resource Governor is configured in two steps. The first step is to specify the configuration you want, the second step is to
ALTER RESOURCE GOVERNOR RECONFIGURE.
sp_configurewhich has a “config_value” column and a “run_value” column, there’s no single view that makes it easy to determine what values are configured, and what values are in use. It turns out that the catalog views are the configured values and the dynamic management views are the current values in use:
Read on for a variety of scripts to help configure resource governor.