SQL Server track Tables usage

Question

Hello, I need to track/get some metrics for some specific Tables of what queries (Select, Insert, Update, Delete), how many times, and who accessed them say for a period of 3 months.

Would SQL Audit be the most efficient/least impact/risks to do this and if yes can someone point me to step by step directions on how to set it up...or if something different recommended I'm open to.

Thanks in advance.

Answer 1

Hi @techresearch7777777 ,

I need to track/get some metrics for some specific Tables of what queries (Select, Insert, Update, Delete),

You can check this link : https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-audit-specification-transact-sql?redirectedfrom=MSDN&view=sql-server-ver16

automatically upon SQL Server start on like when the Server gets rebooted?

I tested on my own I think that it is default to start automatically.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 2

I created a SQL Audit, how can I have this turned on automatically upon SQL Server start on like when the Server gets rebooted?

Thanks in advance.