SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.



Leave a comment on the original post [thakurvinay.wordpress.com, opens in a new window]

Loading comments...