motioneye
asked on
query using dmv vs dbcc memorystatus
I use to run dbcc memorystatus to show me below results, But how do I have same collection via DMV in sql2005 or sql2008 ?
Buffer Distribution Buffers
-------------------------- ---- -----------
Stolen 4560
Free 140
Cached 109863
Database (clean) 664900
Database (dirty) 6969
I/O 0
Latched 0
(7 row(s) affected)
Buffer Counts Buffers
-------------------------- ---- --------------------
Committed 786432
Target 786432
Hashed 671869
Stolen Potential 69922
External Reservation 0
Min Free 256
Visible 194048
Available Paging File 1815943
(8 row(s) affected)
Procedure Cache Value
-------------------------- ---- -----------
TotalProcs 7402
TotalPages 105141
InUsePages 31
(3 row(s) affected)
Buffer Distribution Buffers
--------------------------
Stolen 4560
Free 140
Cached 109863
Database (clean) 664900
Database (dirty) 6969
I/O 0
Latched 0
(7 row(s) affected)
Buffer Counts Buffers
--------------------------
Committed 786432
Target 786432
Hashed 671869
Stolen Potential 69922
External Reservation 0
Min Free 256
Visible 194048
Available Paging File 1815943
(8 row(s) affected)
Procedure Cache Value
--------------------------
TotalProcs 7402
TotalPages 105141
InUsePages 31
(3 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.