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

This section contains the dynamic management views that are associated with the SQL Server services 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.