i have searched this problem but have had no luck find any improvement.
I have a complex application that used stored procedures in SQL server.
Some of the stored procedures use cursors due to the complex nature of the SQL in them.
A few months ago I purchased a new machine expecting an improvement in speed.
The new machine is Xeon E5-2690 single CPU with 32Gig of ram.
The same application runs faster on the new machine as expected. But the database is much slower. One of the stored procedures is more than 20x slower. What takes seconds on the old machine takes minutes on the Xeon machine.
The database and application are identical. I generate the DB from scripts and have done back to back tests with clean empty databases. Still many times slower.
I have searched for answers and tried what little I could find, no help.
I have looked at the settings of SQL server on both machines, many times, and cant find a difference.
I tried turning off HT on the Xeon because I found a post that it helped someone, didn't help me however.
I have started to move some of the DB processing into the applications to try and reduce the time penalty running on the new Xeon.
Any help would be appreciated. Cheers.