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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment