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.

http://msdn.microsoft.com/en-us/library/cc645579.aspx