I am looking for suggestions to troubleshoot a query that executes between 1 and 2 seconds, but takes 20 or minutes to actually retrieve the data. On certain other machines it never finishes.
Index suggestions are non-existent.
There are only several hundred thousands rows, and yes long complicated query. Odd: I can run the query in interactive sql; stop it in the middle of the 'hang', then re-run it, and it returns all of the data in about 5 seconds. As if the cache doesn't know what to do the first time around.
How do I troubleshoot something like this? If I run the plan what am I looking for?
I solved this eventually - there was a hot fix (.3867) that took care of the issue. However, I still would like to know if there is better documentation on how to read the plan information - both graphical and text. I read the docx and clear as mud. There are so many statistics, and it would be nice to know what is 'good' about a certain figure.
answered 15 Apr '13, 01:32