Query takes too long to complete

tmp3B0C.queryanalysis (4.4 MB)
avatar image By Nadir 1 asked Dec 24, 2014 at 05:09 PM
more ▼
(comments are locked)
avatar image SQLkiwi ♦ Dec 25, 2014 at 05:35 AM

Is it possible to provide a post-execution plan? Ideally with the statements run directly from Plan Explorer?

avatar image Nadir Dec 30, 2014 at 04:52 PM

link text

post execution plan uploaded. thanks

mits-execution-plan.sqlplan (4.4 MB)
avatar image Aaron Bertrand ♦ Dec 30, 2014 at 07:11 PM

This plan wasn't generated by running the query from inside Plan Explorer, so it is missing a lot of key metrics like duration, reads, table I/O, etc. Any chance you could provide that?

avatar image SQLkiwi ♦ Dec 31, 2014 at 01:25 PM

That plan still only has estimated numbers. Run the query from Plan Explorer, or at least turn "Actual Plan On" in SSMS and capture the plan from there.

10|10000 characters needed characters left
▼ Viewable by all users
0
0 answers: sort voted first ▼
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

We are Moving!

<p><br></p>

Follow this question

Topics:

x691
x166
x116
x48
x30

asked: Dec 24, 2014 at 05:09 PM

Seen: 166 times

Last Updated: Dec 31, 2014 at 01:25 PM

Related Questions

Any thoughts as to improve upon a Table Insert bottleneck?

optimize this query plan to get better results?

How to eliminate table spool

Query runs over 3 minutes. How can I optimize?

How to optimize the recursive query?

Client's report is timing out. I'm at a loss as to where to begin trying to fix this mess.

Running a query twice, the second one has less IO/cost?

Wrong statistics

The SSRS report wont show up in sql server 2005

any help with this runs 45 min