Merge statement performing extremely slow in SQL 2012

krishna11 2013-10-03 21:56:22

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

SQLkiwi 2013-10-07 01:33:15
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.