Share via

Capture DML

SVA 121 Reputation points
2025-01-14T11:13:07.1666667+00:00

Hi

How can I capture DML operations of a table without impacting the performance. Lightweight process to capture all transactions.

Thanks

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,551 Reputation points
    2025-01-15T02:13:57.8633333+00:00

    Hi @SVA，

    You may also consider using CDC.

    What is change data capture (CDC)

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Was this answer helpful?

    0 comments
  2. Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
    2025-01-14T22:27:36.8066667+00:00

    There are several options, but since you are terse on your requirements, I will say SQL Server Audit is your best choice.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.