motioneye
asked on
memory usage with sql 2005
Hi I had rerun one of the maintenance job which was failed due to memory thrown out error, during the execution I check dbcc memorystaus with following results, which I'm doubts why <buffer dustribution> stolen become negative here, Could someone explain me?
Buffer Distribution Buffers
-------------------------- ---- -----------
Stolen -26978
Free 114756
Cached 337334
Database (clean) 54074
Database (dirty) 20498
I/O 0
Latched 1
(7 row(s) affected)
Buffer Counts Buffers
-------------------------- ---- ----------------
Committed 499709
Target 512830
Hashed 74573
Stolen Potential 416100
External Reservation 0
Min Free 128
Visible 512830
Available Paging File 570686
(8 row(s) affected)
Buffer Distribution Buffers
--------------------------
Stolen -26978
Free 114756
Cached 337334
Database (clean) 54074
Database (dirty) 20498
I/O 0
Latched 1
(7 row(s) affected)
Buffer Counts Buffers
--------------------------
Committed 499709
Target 512830
Hashed 74573
Stolen Potential 416100
External Reservation 0
Min Free 128
Visible 512830
Available Paging File 570686
(8 row(s) affected)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ServicePack version ServerName Edition
-------------------- -------------------- -------------------- --------------------
SP2 9.00.3033.00 Paramountqry Enterprise Edition (
(1 row(s) affected