We have audit trail connected to a DB in a HA setup. The servers restarted over the weekend for patches and Audit Trail would only display old records this morning. Now I did notice that if i refreshed Audit trail the dates were slowly increasing like it was slowly syncing to the database.
So how does Audit Trail work? Why is it slowly syncing this information? Is this an issue with our HA setup for the DB or does Audit Trail just download everything from the database based on the date range set?
On a side note, the audit trail database's views take a long time to load for some reason. Even from within SSMS, so maybe thats why it seems so slow too?