SQLPerformance.com by SentryOne
The Answers.SQLPerformance.com Q & A site has been made read only. Read about the process.
Please visit our support site to ask new query tuning or Plan Explorer questions.

merge join with remote table takes 1 hour

ob123 2015-07-11 19:48:51

Remote query on linked server is 100 precent of costs and runs for 1 hour

/storage/attachments/1299-tmpBA38.queryanalysis
July 11, 2015
No Comments

Post navigation

Unexecuted statement in a proc causes significant perf change
I need to optimize the query ,any suggestion s is welcome

Recent Posts

  • What’s wrong with 2014’s Cardinality Estimate here?
  • identical plans different performance
  • DISTINCT clause degrading performance
  • Why such poor performance from same query in different databases
  • Business objects query with EXCEPT runs slow

Recent Comments

    Archives

    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
    • October 2014
    • September 2014
    • August 2014
    • July 2014
    • June 2014
    • May 2014
    • April 2014
    • March 2014
    • February 2014
    • January 2014
    • December 2013
    • November 2013
    • October 2013
    • September 2013
    • August 2013
    • July 2013
    • June 2013
    • May 2013
    • April 2013
    • March 2013
    • February 2013

    Categories

    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    SentryOne
Sponsor & Curator
    Design and content © 2012-2021 SQL Sentry, LLC.  All rights reserved.  User contributions are licensed under cc-sa with attribution required.