Alert for slow running queries

If we expect all of our queries to less in less than 5 secs and if for
whatever reason, queries run greater than 5 secs , is there a way for SQL
Server to log an event so we can be alerted and investigate.
If not, is there any way to code the application to capture response times
and send an alert to the log if it passes the acceptable threshold ?
We are looking at ways to be proactive and instead of having the customer
call us when things run slow, we want to be the first to know. Are there any
tools out there if not for internally within SQL ? I know you can use
profiler and import the data,etc.. but I am looking for a much faster
response than performing those steps..
ThanksHi Hassan
AFAIK not easily, you can periodically profile and analyse the results,
alternatively you could poll sys.dm_exec_query_stats but this is not the same
as alerts.
John
"Hassan" wrote:
> If we expect all of our queries to less in less than 5 secs and if for
> whatever reason, queries run greater than 5 secs , is there a way for SQL
> Server to log an event so we can be alerted and investigate.
> If not, is there any way to code the application to capture response times
> and send an alert to the log if it passes the acceptable threshold ?
> We are looking at ways to be proactive and instead of having the customer
> call us when things run slow, we want to be the first to know. Are there any
> tools out there if not for internally within SQL ? I know you can use
> profiler and import the data,etc.. but I am looking for a much faster
> response than performing those steps..
> Thanks
>
>