Suspended Query

• vbalaji-609733

  SSC Enthusiast

  Points: 108

  More actions

  January 16, 2008 at 4:23 am

  #120210

  Hi All,

  I am facing the below said problem during peak hours of my producation enviroment

  " A time out occurred while waiting for memory resources to execute the query. Rerun the query."

  Anybody faced such a problem?.. if so please advise the root cause / solution?

  Thanks

• Paul Mu

  SSCertifiable

  Points: 5547

  More actions

  January 16, 2008 at 6:35 am

  #768603

  Try rewriting the query after you have had a look at the query plan.

  Release more memory to SQL Server by either adding more memory and/or use the /3GB switch.

  You may also need to amend the SQL Server max. memory setting.

  Paul