Jose Manuel Jurado Diaz finds excessive resource semaphore waits:
Today, we got a service request that our customer reported that they query are taking too much for their execution. The main wait stats found was RESOURCE_SEMAPHORE and I would like to share with you my lessons learned here.
We executed this query to find out the queries and check the resource semaphore wait type.
Click through for the queries and diagnosis.