监控表活动 [英] Monitor Table Activities

问题描述

我有一个应用程序，包含几个类来从文件中导入数据。导入导致多个表被更新/删除/插入。有许多存储过程和触发器被调用来执行此任务。如何在数据库中的表级监控活动？我想要的是一个受导入影响的表的摘要，插入/删除/更新的模式（通过触发器/存储过程/应用程序）。您的解决方案将非常有用。



提前谢谢。

Hi,

I have an application consisting of several classes to import data from the file. The import results in several tables getting updated/deleted/inserted. There are many of the stored procedures and triggers called to carry out this task. How do I have the activity monitored at the table level in the database? All I want to have a summary of tables affected by the import, the mode of insert/deletes/update (through triggers/stored procedures/application). Your solutions on this would be greatly helpful.

Thank you in advance.

推荐答案

您最好的选择将使用SQL Server扩展事件：

使用SQL Server 2008扩展事件 [ ^ ]



我用它来捕获流氓使用它们不应该运行的查询。由于我不知道你的所有应用程序做了什么，我不能告诉你你需要哪些事件，但文档在这方面非常好。

Your best option will be to use SQL Server Extended Events:
Using SQL Server 2008 Extended Events[^]

I've used this to capture rogue uses running queries they shouldn't be. As I don't know what all your application does, I can't tell you which events you will need, but the documentation is really good on this.

这篇关于监控表活动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！