Merge statement performing extremely slow in SQL 2012

Merge statemet used to run fine SQL 2008. Upgraded inplace upgrade to SQL 2012 SP1. it has been performing slowly since then..

avatar image By krishna11 0 asked Oct 03, 2013 at 09:56 PM
more ▼
(comments are locked)
avatar image SQLkiwi ♦ Oct 07, 2013 at 01:33 AM

The problem appears to be in the Filter. It's impossible to say more from an anonymized plan. If you can, please upload a non-anonymized version so we can see plan details and the query text. Running the query from Plan Explorer instead of importing the sqlplan file from SSMS could show useful extra performance information too. If you still have the plan from SQL Server 2008 that'd be great too, for comparison purposes.

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.