Memory Errors

  • 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

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • Went through KB article but this was not the situation in my environment.:hehe:

    http://support.microsoft.com/kb/838459

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply