SQL Server Audit Event Selection.

Question

Recently our security team request to enable security audit in MSSQL. I am afraid enable all the action may extremly slow down the DB performance. Any suggestions on server specification?

Answer 1

Hi @Elon Musk
Here is an article showing the best practices that should be followed to have a successful auditing strategy that complies the company audit policies and requirements.
SQL Server Auditing Best Practices

Best regards,
LiHong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Well, that depends on what exactly you plan to audit. If the security team would ask every table access to be audit, I might be a little worried if this an OLTP system. Less excessive auditing should not be a problem.