Query takes too long to complete

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

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

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!


Follow this question



asked: Dec 24, 2014 at 05:09 PM

Seen: 166 times

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