I submitted this request in as a feature enhancement but I was told it has a low priority. Personally I think it would be very good to have an alert (visual and email) to let us know if a query, batch, etc. exceeded a certain time.
So I figured I'd come to the forums and see if anyone else has considered this or has come up with a solution.
If you have come up with a solution, what was it? I'm still digging around in Foglight to see if I can figure anything out but I know there are CME's in Foglight that have way more experience than I do with it.