存储过程执行时间过长时的 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屋！