Application users were complaining that web applications were slow. Turned out there were some bad queries that were requesting up to 1GB of SQL RAM to execute. It's no wonder SQL was suspending queries waiting for memory...
Reference:
http://www.mssqltips.com/sqlservertip/2827/troubleshooting-sql-server-resourcesemaphore-waittype-memory-issues/
http://blogs.msdn.com/b/sqlqueryprocessing/archive/2010/02/16/understanding-sql-server-memory-grant.aspx
Showing posts with label RESOURCE_SEMAPHORE. Show all posts
Showing posts with label RESOURCE_SEMAPHORE. Show all posts
Thursday, June 20, 2013
Subscribe to:
Posts (Atom)