存储过程执行时间过长时出现SQL警报 [英] SQL Alert when stored procedure executes for too long

问题描述

我想设置一个SQL Server 2008警报以在任何过程执行1秒或更长时间时通知我(仅作为示例).

I would like to set up a SQL Server 2008 Alert to notify me when any procedure executes for 1 second or longer (just an example).

有什么想法吗?

好的，看来这是不可能的.但是，只是为了向您转移另一个方向，我知道master数据库中有一些统计表，其中包含编译计数，调用次数和其他各种统计信息.我可以定期查询它们，然后以某种方式对其进行报告吗?

Okay, it seems this is not possible. But, just to nudge you in another direction, I know that there are statistics tables in the master database which hold compilation counts, number of calls and other various statistics. Could I maybe periodically query them and then report on it, somehow?

推荐答案

否，对此没有通知. 您将不得不设置跟踪并不时地对其进行轮询.

no there are no notifications for this. you'll have to set up a trace and poll it every now and then.

这篇关于存储过程执行时间过长时出现SQL警报的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！