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)
motioneyeAsked:
Who is Participating?
 
dbaSQLConnect With a Mentor Commented:
I'm not sure about the output you've posted, but check these two out for your buffer details:
http://www.sqlservercentral.com/blogs/glennberry/archive/2010/04/30/a-dmv-a-day-_1320_-day-30.aspx
http://www.mssqltips.com/tip.asp?tip=2194

And you can use sys.dm_exec_procedure_stats for your procedure cache stats. These are both very good references:  http://www.simple-talk.com/content/print.aspx?article=1215
http://www.sqlservercentral.com/blogs/glennberry/archive/2010/04/10/a-dmv-a-day-_1320_-day-10.aspx

0
All Courses

From novice to tech pro — start learning today.