Long-running query

RhysRhys Posts: 35
edited December 21, 2010 5:39AM in SQL Monitor Previous Versions
We've had loads of alerts raised for a stored procedure we know never takes more than 2 seconds. Alerts are set for > 60 seconds.

If the connection is reused will SQL Monitor identify multiple executions of the same proc as a single query?

How is a long running query identified?

Comments

  • Hi Rhys

    There was a bug in long running query alerting in the 2.0 EAPs but it should have been fixed from 2.0 onwards.

    Every time we see a running query, we make a note of the date. The duration of the query is simply the difference between the current date and the first date that we saw the query.

    We determine that it is the same query by using a combination of the process ID, the login date, and the last batch date.

    Hope this helps.
    Ben
Sign In or Register to comment.