I have MS SQL 2000 Server SP3 cluster in active/active mode, windows 2003
with 4GB of RAM and 2 Intel Zeon CPU of 2.80 Ghz.

In the SQL Server Logs appear a lot of messages like this...



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

Buffer Distribution: Stolen=2570 Free=3319 Procedures=1139
Inram=0 Dirty=1205 Kept=0
I/O=0, Latched=24, Other=94280

Procedure Cache: TotalProcs=523 TotalPages=1139 InUsePages=555

Dynamic Memory Manager: Stolen=3709 OS Reserved=1680
OS Committed=1643
OS In Use=1633
Query Plan=1105 Optimizer=0
General=4022
Utilities=9 Connection=151

Global Memory Objects: Resource=1582 Locks=55
SQLCache=73 Replication=2
LockBytes=2 ServerGlobal=42
Xact=12

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

I don't know what is happening.

Thanks in advance

do any of these apply?

http://support.microsoft.com/search/...rce=gASr_Query

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html


"David" <acostaa (AT) gmail (DOT) com> wrote