@schwizla - did you find the solution to this? we are planning on doing similar upgrade. Do you mind posting the solution?

Thanks

Jagan K

we are able to match up the execution plan by throttling the max memory setting in Server 1.

Here's the KB http://support.microsoft.com/kb/2413549 that explains more memory could sometimes cause inefficient...

Grent/Robert/Sean, Attached are the good and bad plans. These are obtained after refreshing Server2. Still the server configuration is same as before(not identical memory wise). We ran the query without...

Yes. Same version and Save SP level

RObert, I'm in the process of synching my Server2 from Server 1. Once, its complete, will send the results.

Robert klimes (10/6/2014)

---

First, Hardware is not identical, server 1 has twice as much memory as server two.

Second, the plans you provided use different values for the parameters.

good plan: [@dtImportOrder]= '2014-10-01...

The database was restored from Server 1 to Server 2. So, the Stats and Index fragmentation should be same.

According to what I see in the Execution Plans, There is...

please.. can someone help me out here:crying:

Jason, Thank you very much for the quick post. I was staring at plan attributes this whole time without knowing its advantage. :Wow:

I started anayzing the SQLs from the result...

Hello Luis, Thank you for the reply, but you misstook me for finding if there is a query hint in the sql proc Vs SQL optimizer determining if it has...

can someone please shed some light. i want to know the root cause of this issue.

Thanks

Did you also hook up the mail profile in sqlagent's Alert system tab. I don't think this will have any impact on using dbmail through a procedure. But, worth a...

Hello, Thank you so much for responding for my thread. I am going to share my thoughts here out loud so that someone can guide me in the right...

Hello, Thank you so much for responding for my thread. I am going to share my thoughts here out loud so that someone can guide me in the right...

Can one of the gurus help me please...:crying: