October 10, 2017 at 11:45 pm
Just released that SQL 2016 Standard edition does not support Database Audit Specification. After some research, found out that others are using SQL Server Profiler to track events but the down side is Profiler taking up much overhead. Not sure how much utilization used if always turned on and would it crash the server
Do you guy have any other suggestion/tools to capture SQL events logs for Audit purpose?
October 11, 2017 at 7:41 am
I believe 2016 Standard has a smaller set of auditing options than Enterprise, but Database Audit Specification is still supported. I'm currently running it on one database on a 2016 Standard installation auditing schema changes and I had it running briefly on insert/update/delete/select.
October 11, 2017 at 12:44 pm
Since 2016 SP1, it's supported on all editions. It's mentioned in the documentation:
SQL Server Audit
Sue
October 11, 2017 at 8:25 pm
Thank you both!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply