Is it possible to provide a post-execution plan? Ideally with the statements run directly from Plan Explorer?
post execution plan uploaded. thanks
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?
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.
Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.
Answers and Comments
query plan x670
plan explorer pro upload x166
poor performance x112
slow query x48
asked: Dec 24, 2014 at 05:09 PM
Seen: 145 times
Last Updated: Dec 31, 2014 at 01:25 PM
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?
The SSRS report wont show up in sql server 2005
any help with this runs 45 min
© 2013 SQL Sentry, Inc. All rights reserved.