Resource_Semaphore

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

yihyoonl Old Hand Points: 319 More actions · Answer 1

Waittype of resource_semaphore indicates a wait on memory grant. Here is an article that may be related.

If there were SPIDs waiting on Resource_Semaphore, this is a symptom

indicating that there is some other query/queries which are taking too much memory and not releasing quickly enough.

Yih-Yoon Lee

Yih-Yoon Lee
lee@yihyoon.com