can we have PI AF audit trail with SQL 2016 Express Edition?
or should we use only Standard or Enterprise Edition?
we are using SQL Express 2016 and wanted to enable audit trail for PI AF.
how can we enable it using 'PIAFdiag' command?
PI AF Audit Trail requires the "Change Data Capture" feature of SQL Server, which requires the Agent to be installed. That does not come with the Express edition.
Steve is correct.
Something to consider, enabling AF Audit Trail approximately doubles the amount of data in the AF Server. Of course, since the data is approximately doubled, the load on SQL will also be approximately doubled. Please make sure your hardware can support the additional load with audit enabled.
To those reading, change data capture (CDC) is available in the standard edition of SQL as of 2016 SP1. Previously enterprise version was required for CDC.
Hope this helps, Seb
Thank you Raposo
thank you Steve
Retrieving data ...