Skip to main content
< All Topics
Print

Why can’t I see schema changes or errors in the logs?

Schema changes and errors are collected locally on each individual SQL Server in an in-memory ring buffer. When the buffer is full (or 30 seconds have passed), the ring buffer is flushed to disk. If very few schema changes or errors are occuring, the buffer is not written to disk until 30 seconds have passed.

The schema changes and errors are then collected in the interval stated in the “Collect audit information every” and “Sample servers every” entries (default value: 30 seconds) in the Settings menu:

So if very few schema changes or errors occurs, a delay of up till 30 seconds + the “Collect audit information every/Sample servers every”-seconds can happen before the schema changes can be seen in dbo.v_audit and the errors in dbo.v_errors.

See also: I have added a server but no information is collected?

Table of Contents