How to Fix RESOURCE_SEMAPHORE Wait Type in SQL Server?
RESOURCE_SEMAPHORE waits occurs when a query memory request cannot be granted immediately due to other concurrent queries. High waits and…
14 years ago
Performance Tuning
What is SQL Server Wait Type? or How to get wait type info in sql server?
Wait Types are awesome way to troubleshoot performance related issues. In SQL Server 2005 and later version we can get…
14 years ago