What is RESOURCE_SEMAPHORE in SQL?
RESOURCE_SEMAPHORE:
Occurs when a query memory request cannot be granted immediately because of other concurrent queries. High waits and wait times can indicate excessive number of concurrent queries or excessive memory request amount.
COMMON for DSS like workload and large queries such as hash joins; must wait for memory quota (grant) before it is executed.
No comments:
Post a Comment