Question

Which of the following Dynamic Management Views (DMVs) should you use if you want the list of all audits defined on an instance of SQL Server and their current status?

a. sys.dm_audit_actions
b. sys.dm_server_audit_status
c. sys.dm_audit_class_type_map
d. sys.server_audits

Answer 1

To find the list of all audits defined on a SQL Server instance and their statuses, use the DMV sys.dm_server_audit_status, which includes audit running status and event counts.

Step-by-step explanation:

If you want the list of all audits defined on an instance of SQL Server and their current status, you should use the sys.dm_server_audit_status Dynamic Management View (DMV).

This DMV provides information on each audit, including whether the audit is currently running and the number of audit action groups and audit events that have fired since the SQL Server instance has started or since the audit has started. Using this DMV, you can easily monitor the health and performance of your server audits, ensuring compliance with your audit policies.