Monitoring Resource Usage
SQL Server provides three dynamic management views you can use to view and monitor your Resource Governor configuration:
sys.dm_resource_governor_workload_groups—Returns workload group statistics along with the current in-memory configuration of the workload groups.
sys.dm_resource_governor_resource_pools—Returns information about current state of your resource pools and resource pool statistics.
sys.dm_resource_governor_configuration ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
