Home > database >  A database SQL server how to effectively monitor all the tables about DML operations in it
A database SQL server how to effectively monitor all the tables about DML operations in it

Time:05-22

All I know is essentially provides the DML trigger used to DML operations on the table level

But a repository has a lot of table, I need to monitor all in place, so that the trigger to create more troublesome

Only DDL triggers, and database level trigger, and languages to truncate the DDL can monitor,

Also have thought of detector with events, but I need to monitor this thing relative to the content of the restrictive too big (resources, deployment, etc.)

Question:

1. How to monitor the truncate the operation

2. How to monitor each table in database level DML language operation
  • Related