Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    6

    Unanswered: Insufficient Memory Error

    My company has a database that is throwing a weird error. We've tried reinstalling both the OS and the SQL instance, and the error still persists. We think this error might have to do with some .NET code we've written to run on the box, but I cannot find anything out on the internet about it. Here is the Enterprise Manager Error Log:

    Code:
    Insufficient memory available..
    Error: 17803, Severity: 20, State: 4
    Query Memory Manager:  Grants=0 Waiting=0 Maximum=97638 Available=97638
    Global Memory Objects:  Resource=912 Locks=42 
    		SQLCache=67 Replication=2
    		LockBytes=2 ServerGlobal=20
    		Xact=12
    Dynamic Memory Manager:  Stolen=2138 OS Reserved=1048 
    		OS Committed=1026
    		OS In Use=1022
    		Query Plan=1777 Optimizer=0
    		General=1066
    		Utilities=12 Connection=262
    Procedure Cache:  TotalProcs=488 TotalPages=1787 InUsePages=542
    Buffer Counts:  Commited=5168 Target=131072 Hashed=1917
    		InternalReservation=191 ExternalReservation=0 Min Free=128 Visible= 131072
    Buffer Distribution:  Stolen=351 Free=1113 Procedures=1787
    		Inram=0 Dirty=599 Kept=0
    		I/O=0, Latched=23, Other=1295
    WARNING:  Failed to reserve contiguous memory of Size= 65536.
    I can find information if I do a Google search on "Error: 17803, Severity: 20" But as soon as I add "State: 4" to the query I get no results. Also, the articles that I have seen that give the same error messages (but different states) tend to deal with servers that have more than 4GB of memory. This server has ONLY 4GB of memory and in order to try and resolve this issue, we have limited the server to 1GB of physical memory to no avail.

    Any help would be appreciated. Thanks!

  2. #2
    Join Date
    May 2002
    Posts
    299
    You'd want to update your sqlserver.

    http://support.microsoft.com/kb/891719
    --
    -oj
    http://www.rac4sql.net

  3. #3
    Join Date
    Sep 2005
    Posts
    6
    I forgot to mention that I'm running MSSQL 2000 SP4. So if there is an update beyond SP4 that I don't know about, please let me know.

  4. #4
    Join Date
    May 2002
    Posts
    299
    check your @@version to ensure you're on the sp4. I've seen cases where the sp did not install.

    If you're indeed on sp4, you might want to contact PSS because this looks like an internal bug - your fee should be reversed when you get to the support engr.
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •