I have written a stored procedure that I am reasonably happy with. It is run rarely so performance is not a major issue. It takes 2.5 minutes on my i5 4Gb SQL server 2012 11.0.3128.0 It's made up of a couple of recursive loops.
I have just purchase a new MSI all bells and whistles GS60 notebook with 16GB Ram 2 * 128GB SSD Drives an i7 processor and a pretty keyboard.
I installed the same SQL Server software off the same DVD.
Created and restored a backup from my old notebook and sat back expecting fire and brimstone to come out as the query ran. 6 minutes!. A little confused at this point.
Is there anyone out there that could point me in the direction to investigate.
I looked at the performance manager as it ran and it all seems to run on one core.
SQL Server seems to have 5GB RAM allocated . The entire database is less than 100MB