Denali – Day 14: New DMV & DMF

Denali – Day 14: New DMV & DMF


As there has been so many DMV/DMF already introduced in earlier version of Sql server, Denali does not have much on this part, but 5 new dmv/dmf and 1 modified here most of the stuff is related to OS, below are the list.

sys.dm_exec_query_stats (Transact-SQL) – 4 new columns has been added on this. total_rows , last_rows
,min_rows, max_rows

sys.dm_os_volume_stats (Transact-SQL) -> This DMF shows IO volume information statistics on the server.

sys.dm_os_windows_info (Transact-SQL) -> this is another one which shows Windows information from sql server like systeminfo.


sys.dm_server_memory_dumps (Transact-SQL) -> shows memory dump information.

sys.dm_server_services (Transact-SQL) -> Sql server services related information

sys.dm_server_registry (Transact-SQL) -> All registry information.

This entry was posted in Add/remove, Denali, DMV, Whats New and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.