What is SQL Server resource semaphore and memory grant starvation?

Resource semaphore controls memory grant allocation and can cause starvation under pressure.

When queries request memory for sorts or hashes, they must acquire a memory grant via resource semaphore. If memory is insufficient, queries wait in a queue, leading to RESOURCE_SEMAPHORE waits. Severe contention causes query starvation and throughput collapse.