Insufficient memory Available

• growl

  Hall of Fame

  Points: 3068

  More actions

  August 20, 2004 at 11:38 pm

  #83706

  Hi all, last night one of production sql servers service hung and required a reboot.

  I was unable to get much out of the event viewer. However I found this in the SQL Server log

  it repeated this for about an hour before the service was killed and system rebooted.

  SERVER            Insufficient memory available. Error: 17803 Severity:19 state 1

  The schedulert 1 appears to be hung. SPID 89,ECID 0, UMS Context 0x03d20090.

  This server has approx 43 databases on it. The largest being 23 gig (read only/standby)

  SQL Server 2000 standard edition sp3a. Windows Server 2000 service pack 4.

  4g ram Dual Intel XEON 3.0 GHz .

  Help!

   

   

• August 23, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Arvind-57714

  SSCrazy

  Points: 2529

  More actions

  August 27, 2004 at 1:22 pm

  #520945

  Maybe its related to this...check this out in any case...

  http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fbin%2Fkbsearch.asp%3FArticle%3D313279

   

  Cheers!

  Arvind

  
  Arvind