Audit not enabled

Comments are closed
How can we help?
< All Topics
Print

Audit not enabled

Audit is a vital part of Performance Store and for compliance reasons.

The following should be verified, and must be in place for the audit to work:

  • The Service Broker must be enabled on the msdb database.
  • The Service Broker must be enabled on the Performance Store management database:

Audit can be enabled by disabling and enabling monitoring on the SQL Server.

To query the Performance Store database for SQL Servers where audit is not enabled, use:

select s.*
from dbo.v_servers s
where 1 = 1
and s.audit_enabled = 0

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents