trouble shooting resource semaphore waits

The following query will show where the waits are and if other groups have unused minimum amounts assigned

SELECT name ,
active_memgrant_count ,
active_memgrant_kb ,
memgrant_waiter_count ,
min_memory_percent ,
max_memory_percent
FROM sys.dm_resource_governor_resource_pools
ORDER BY pool_id

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: