I don't know if anyone has ever encountered this strange behaviour, it certainly sounds like like nonsense so am I missing something?
Here's the facts:
I am writing a query in ssms, reasonably complicated, with temp tables, linked servers and lots of lookup/transformation steps. When testing, I am trying to find some performance optimisations and have included the execution plan (Ctrl + M).
After running dbcc freeproccache and dropcleanbuffers, I run the query, it takes 1 sec. That's reasonable, so I Ctrl + M again and retry, after proccache/cleanbuffers.
The query then takes 15 secs to complete!
When buffered, it still runs in 1 sec though.
Have any of you experianced anything similar?
Can you think of any good explanations for this?
I've tried this several times, the results are the same.
--------------------
Procrastinate Now!
Here's the facts:
I am writing a query in ssms, reasonably complicated, with temp tables, linked servers and lots of lookup/transformation steps. When testing, I am trying to find some performance optimisations and have included the execution plan (Ctrl + M).
After running dbcc freeproccache and dropcleanbuffers, I run the query, it takes 1 sec. That's reasonable, so I Ctrl + M again and retry, after proccache/cleanbuffers.
The query then takes 15 secs to complete!
When buffered, it still runs in 1 sec though.
Have any of you experianced anything similar?
Can you think of any good explanations for this?
I've tried this several times, the results are the same.
--------------------
Procrastinate Now!
