Server-Related Dynamic Management Views and Functions (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This section contains the dynamic management views that are associated with the SQL Server, Full-text, and SQL Server Agent services that are installed on the host server. You can use these views to return property information for these services. These views also contain configuration, installation, and memory dump file information.

In This Section

sys.dm_server_memory_dumps sys.dm_server_services
sys.dm_server_registry