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
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.