Error: 17803, Severity: 20, State: 12

tolywang發表於2010-05-13
Windows 2003 , 32bit,  SQL Server 2000 sp4 , 32bit  .  
報下面的錯好幾次了 , 不定期 , 是虛擬記憶體的問題  ?   


Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date:  5/12/2010
Time:  3:43:14 PM
User:  N/A
Computer: SQLAPPDB
Description:
Error: 17803, Severity: 20, State: 12
Insufficient memory available.
For more information, see Help and Support Center at
.
Data:
0000: 8b 45 00 00 14 00 00 00   ‹E......
0008: 09 00 00 00 53 00 51 00   ....S.Q.
0010: 4c 00 41 00 50 00 50 00   L.A.P.P.
0018: 44 00 42 00 00 00 05 00   D.B.....
0020: 00 00 44 00 45 00 4c 00   ..D.E.L.
0028: 4c 00 00 00               L...   



WARNING:  Failed to reserve contiguous memory of Size= 203620352.

Buffer Distribution:  Stolen=51061 Free=29 Procedures=15069
  Inram=0 Dirty=4669 Kept=0
  I/O=0, Latched=45, ther=3769127

Buffer Counts:  Commited=3840000 Target=3840000 Hashed=3773832
  InternalReservation=276 ExternalReservation=0 Min Free=3072 Visible= 138904

Procedure Cache:  TotalProcs=6335 TotalPages=15069 InUsePages=4991

Dynamic Memory Manager:  Stolen=66139 OS Reserved=1200
  OS Committed=1178
  OS In Use=1163
  Query Plan=15004 ptimizer=0
  General=1882
  Utilities=138 Connection=49625

Global Memory Objects:  Resource=995 Locks=250
  SQLCache=637 Replication=2
  LockBytes=2 ServerGlobal=21
  Xact=118

Query Memory Manager:  Grants=0 Waiting=0 Maximum=65481 Available=65481

Error: 17803, Severity: 20, State: 12     Insufficient memory available..

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-662560/,如需轉載,請註明出處,否則將追究法律責任。

相關文章