July 2, 2010 at 1:37 am
I am getting the below errors on SQL Server Error Log. They are not continues but occurs just for a particular duration for approx 2 mints. To me they seems to be related to memory as SQL is not getting enough memory to perform certain operations and it might trying to adjust B.Cache and P.Cache. However, if somebody who probably faced this earlier or have some depth knowledge about it, can suggest me:
I am running SQL Server 2000 EE with SP4 (32-bit Platform)
2010-07-01 08:30:14.31 spid127 Buffer Distribution: Stolen=152976 Free=1054 Procedures=38
Inram=0 Dirty=113473 Kept=0
I/O=0, Latched=756, Other=1580023
2010-07-01 08:30:14.31 spid127 Buffer Counts: Commited=1848320 Target=1848320 Hashed=1694252
InternalReservation=1265 ExternalReservation=0 Min Free=984 Visible= 154896
2010-07-01 08:30:14.31 spid127 Procedure Cache: TotalProcs=2 TotalPages=38 InUsePages=35
2010-07-01 08:30:14.31 spid127 Dynamic Memory Manager: Stolen=153006 OS Reserved=1464
OS Committed=1424
OS In Use=1279
Query Plan=1300 Optimizer=127027
General=17927
Utilities=174 Connection=7593
2010-07-01 08:30:14.31 spid127 Global Memory Objects: Resource=4351 Locks=135
SQLCache=597 Replication=2
LockBytes=2 ServerGlobal=45
Xact=50
2010-07-01 08:30:14.31 spid127 Query Memory Manager: Grants=0 Waiting=0 Maximum=56 Available=56
2010-07-01 08:30:14.40 spid1150 Buffer Distribution: Stolen=152843 Free=1060 Procedures=165
Inram=0 Dirty=113473 Kept=0
I/O=0, Latched=755, Other=1580024
2010-07-01 08:30:14.40 spid1150 Buffer Counts: Commited=1848320 Target=1848320 Hashed=1694252
InternalReservation=1265 ExternalReservation=0 Min Free=984 Visible= 154896
2010-07-01 08:30:14.40 spid1150 Procedure Cache: TotalProcs=4 TotalPages=165 InUsePages=37
2010-07-01 08:30:14.40 spid1150 Dynamic Memory Manager: Stolen=153000 OS Reserved=1464
OS Committed=1424
OS In Use=1279
Query Plan=1302 Optimizer=127024
General=17926
Utilities=174 Connection=7589
2010-07-01 08:30:14.40 spid1150 Global Memory Objects: Resource=4351 Locks=135
SQLCache=597 Replication=2
LockBytes=2 ServerGlobal=45
Xact=50
2010-07-01 08:30:14.42 spid1150 Query Memory Manager: Grants=0 Waiting=0 Maximum=56 Available=56
July 2, 2010 at 2:20 am
Went through KB article but this was not the situation in my environment.:hehe:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply