itsmeman (7/13/2010)
I discovered that the queries in question were victims because of SQL jobs running causing them to die. Just seems odd that the duration would go so long. I can't make the mental connection between the two.
Contention on resources. Process 1 normally runs in 30 seconds, but it needs a table that is in exclusive lock by Process 2. Process 2 runs in 5 minutes. Process 1 completes in 5 minutes and 30 seconds because it has to wait for Process 2 to run.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning