存储过程执行时间过长时的 SQL 警报
我想设置一个 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.
相关文章