There are couple of new DMV’s. But I would like
to share with you all.Some Useful new DMV’s in SQL Server 2012 and SQL Server
2008 R2 SP1
sys.dm_os_windows_info: This DMV will get you OS
related information of the Server.
sys.dm_server_registry: This DMV will get you
information on registry keys which are used by the server.
sys.dm_server_memory_dumps : This DMV will get
you information on dumps which are generated by the server.
