question

susan_2012 avatar image
susan_2012 asked

Resource Semaphore

Hi, We encountered a scenario where in the application completely freezes and the Resource Semaphore waits indicate the system is out of memory. I don’t know if the huge number of processes on this system had consumed it all and the procedure that was executing (Proc A) needed more than was free to execute or if Proc A compiled such a bad plan that it needed such a huge amount the system could not provide it. For Proc A this is what we got from the DMVs WaitTime - 177344 and LastWaitType - RESOURCE_SEMAPHORE Any suggestion would be highly appreciated. Thanks in advance, Susan
performance
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What version of SQL Server? And Windows? How much memory is allocated to SQL Server, and how much has the server got? Is this one particular procedure that's causing the problem, or are there others? If it's one procedure, perhaps it can be improved...
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.