I have a select statement that usually returns in subsecond time, but
occasionaly it seems to hang and doesn't return for several minutes the
largest of which has been about 15 minutes. I am not sure where to
start looking for the problem, I have used profiler to see if some other
transaction is holding it up but that does not appear to be happening
either. Any suggestions would be appreciated?