New Dynamic Management Views

New T- Administration features in SQL server 2012

New Dynamic Management Views (DMVs)

This returns “sys.dm_server_memory_dumps “a simple list of any memory dumps that SQL Server has created, detailing filename, creation time, and size (in bytes) of the file. It is useful in troubleshooting scenarios on those (exceptionally rare) occasions when SQL Server creates a memory dump.

SELECT * FROM sys.dm_server_services

This query return information about the current SQL Server instance's Windows services, including information about whether the services are clustered.

Below Query related information from the registry for all instances, it is useful to anyone who has ever attempted to write a monitoring tool or perform custom auditing of their SQL Server environment

SELECT * FROM sys.dm_server_registry

SELECT * FROM sys.dm_os_windows_info

It is helpful to details of the operating system that can be used for auditing your servers.

New OS Volume Stats DMV

It returns information about the file system for any given file for any database.

The following example returns data about the log file (file_id: 2) for the master database (database_id: 1)

SELECT * FROM sys.dm_os_volume_stats (1,2)