| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | |
|---|---|---|---|---|---|---|---|---|---|
Server related dynamic management views and functions (Transact-SQL) |
Server related dynamic management views and functions (Transact-SQL) |
rwestMSFT |
randolphwest |
03/06/2017 |
sql |
system-objects |
reference |
|
[!INCLUDE SQL Server]
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.
:::row::: :::column::: sys.dm_server_accelerator_status sys.dm_server_audit_status sys.dm_server_external_policy_actions sys.dm_server_external_policy_principal_assigned_actions sys.dm_server_external_policy_principals sys.dm_server_external_policy_role_actions :::column-end::: :::column::: sys.dm_server_external_policy_role_members sys.dm_server_external_policy_roles sys.dm_server_memory_dumps sys.dm_server_registry sys.dm_server_services sys.dm_server_suspend_status :::column-end::: :::row-end:::