Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Server becomes very slow [RESOURCE_SEMAPHORE] waittype. RE: Server becomes very slow [RESOURCE_SEMAPHORE] waittype.
andyansryan
SSC Journeyman
Points: 79
More actions
September 19, 2012 at 1:07 pm
#1539759
We had the same issue. Initially we did not think it was memory bottlenecks since cache hit ratio was around 100. But we increased the server memory and the issues went away for now.