DBCC MEMORYSTATUS

Last Post 23 Feb 2007 11:07 AM by gujsa01. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
gujsa01
New Member
New Member

--
22 Feb 2007 01:15 PM
Hi,

Following is the first section of DBCC MEMORYSTATUS:
BufferDistribution Buffers
Stolen -362
Free 802
Procedures 50095
Inram 0
Dirty 3036
Kept 0
I/O 0
Latched 63
Other 282790

Stolen counter has a value of -362
gujsa01
New Member
New Member

--
22 Feb 2007 01:18 PM
Was wondering why would this Stolen counter be negative if is used for sorting and hashing operations.
gujsa01
New Member
New Member

--
22 Feb 2007 02:06 PM
SQL Server 2000 Enterprise Edition with SP4
gujsa01
New Member
New Member

--
23 Feb 2007 11:07 AM
Unfortunately I had to leave for th day and couldn't check this counter via Perfmon last night. This morning things look positive.

Is there anything else I'm missing to look for the negative value??
You are not authorized to post a reply.

Acceptable Use Policy