Whats your longest running query

I just found this on a hosted SQL server I use. The query was trying to enable service broker and was just waiting for an exclusive database lock which it wasn’t getting.

So it was sitting there for 58 days.

 

image

Do you have a query thats been running for longer ?

Published 14 October 2011 01:34 by simonsabin
Filed under:

Comments

14 October 2011 02:57 by SimonS Blog on SQL Server Stuff

# Whats your longest running query

I just found this on a hosted SQL server I use. The query was trying to enable service broker and was

18 October 2011 12:42 by Craig Ottley-Thistlethwaite

# re: Whats your longest running query

That's crazy!! The longest query I've had running is 26 hours by using linked servers to Oracle