December 22, 2011 at 7:53 am
Hi there,
Express R2:
A multi-table/inter-server script that needed < 2min to finish yesterday could not be executed today
- or better - : I terminated the query after 15min.
Nothing happened after I reorganized/rebuilt all indexes involved.
But what helped was to add Index Hints. Now it is working as smooth as always...
So... any guess what happened?
I am now working in a new environment with lots of vm-servers and inter-server queries: in my old job I never thought of using /needed them, and I wouldn't like to add them in every query.
Kind Regards
Arthur
December 22, 2011 at 8:34 am
Post execution plan please (of the one without the hints). Actual plan if at all possible, estimated only if you cannot run the query to completion at all.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2011 at 9:17 am
Sorry, no plan.
Do you have good guesses why a query can fail all of a sudden even though no changes have happened in the table contents?
Kind Regards
Arthur
December 22, 2011 at 10:01 am
Sure, got an hour or so? 😉
There are lots of possible causes. Most likely would be a 'tipping' point in the data volume.
Are you certain that there has been no data changes, not even a single row insert?
To do anything more than make vague guesses, I need to see an exec plan. Any reason why you can't post one?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply