Why can't I match longest running queries report tile to a long running query alert
A co-worker told me I had better look at one of his sql monitor reports because I had a query that was taking longer than a day to run. He has the Longest running queries tile included in his report. I cannot find a query alert with anywhere near the duration he showed. Is that report tile perhaps adding up the total time a given query ran over several executions? His report was for the duration of a week.