|
| Hi,
I have SQL server 2000 Enterprise edition SP4 on Windows Advanced server
with SP1 and start to have the following error messages since yesterday
afternoon:
2006-03-14 09:12:10.53 spid115 WARNING: Failed to reserve contiguous
memory of Size= 25296896.
2006-03-14 09:12:10.56 spid115 Buffer Distribution: Stolen=10502 Free=517
Procedures=23501
Inram=0 Dirty=26314 Kept=0
I/O=0, Latched=370, Other=277124
2006-03-14 09:12:10.56 spid115 Buffer Counts: Commited=338328
Target=338328 Hashed=303808
InternalReservation=
651 ExternalReservation=
0 Min Free=1024
2006-03-14 09:12:10.56 spid115 Procedure Cache: TotalProcs=6248
TotalPages=23501 InUsePages=6610
2006-03-14 09:12:10.56 spid115 Dynamic Memory Manager: Stolen=34003 OS
Reserved=2784
OS Committed=2771
OS In Use=2745
Query Plan=22782 Optimizer=0
General=4797
Utilities=354 Connection=6552
2006-03-14 09:12:10.56 spid115 Global Memory Objects: Resource=3320
Locks=834
SQLCache=580 Replication=2
LockBytes=2 ServerGlobal=58
Xact=91
2006-03-14 09:12:10.56 spid115 Query Memory Manager: Grants=0 Waiting=0
Maximum=242019 Available=242019
2006-03-14 09:12:10.64 spid115 Error: 17803, Severity: 20, State: 12
2006-03-14 09:12:10.64 spid115 Insufficient memory available..
We have a dedicated server for SQL Server and has 4.0 GB physical memory
with /3GB switch in boot.ini file.
Any information on this will be greatly appreciated.
Thanks,
Sang Nahm
|
|