"

What load does SQL audit generate for a SQL server?

Last review: Jan 01, 2013
https://kb.netwrix.com/653
Copy Article URL Copied

What load does SQL audit generate for a SQL server?


Most noticeable impact on your SQL servers would be during the initial data collection. Netwrix Auditor runs several SQL scripts to build and store a ‘baseline’ of data against which it will compare future collections.

However, even this initial collection will result in very little performance impact unless you are already running your servers at capacity. During subsequent data collections the impact will be lower and with the daily collections running at 03.00 AM unless you are running large jobs on the server at that point, there should be little to no effect on the performance of your monitored systems.

If you are running large jobs on your SQL servers during off-hours, please consider avoiding 03.00 AM time.

Go Up