16.6. Monitoring resource usage
Workload groups and resource pools can be monitored using three methods: Performance Monitor, events, and Dynamic Management Views.
16.6.1. Performance Monitor
Performance Monitor is the primary mechanism for monitoring Resource Governor usage in SQL Server 2008. Two performance objects are available: SQLServer:Workload Group Stats and SQLServer:Resource Pool Stats.
We saw an example of using the CPU Usage % counter from the SQLServer: Resource Pool Stats earlier in figure 16.5. SQL Server Books Online documents all of the counters for these objects, but let's briefly have a look at some of the counters available for SQLServer:Workload Group Stats:
Queued Requests—If you're using the GROUP_MAX_REQUESTS argument ...
Get SQL Server 2008 Administration in Action 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.
