A asp.net page doing very slow to load a list from SQL Server has increased it's performance very much after the whole database has been restored on a new SQL Server. The asp.net app has moved from and to the same servers.
The page's performance has improved to something about 1/5 of the previous load time.
The new system even has less Memory (12 GB instead of 30 GB). - on the old SQL Server is restricted to use 20 GB of 30 GB and it claims 20 GB. - on the new SQL Server is restricted to use 8 GB of 12 GB and it actually claims 4.5 GB only
The new system has an Intel Xeon E CPU while the old has an Intel Xeon X CPU.
Users say the performance has improved since the moving in general.
Unfortunately I have no benchmark of the page and/or the queries I am investigating on and also not for the involved servers at all.
This behavior is the opposite of my expectations!
So the question is, what could possibly have improved this?
Do statistics possibly play a role here? I would guess they are part of the db and so included in the restored db - or have they been created from scratch? Any thoughts and ideas are very welcome.
EDIT 11-March 2016:
I tested disk performance of both systems: The old disk performance made 0,3 MB/S to 55 MB/s with Average of 30 Mb/s. The new system shows 141 Mb/s to 1690 Mb/s with average 803 Mb/s. So since the disk performance seems to be more than 10x better, I guess this maybe a good reason for better performance. We are having a lot of disk usage because of bad design (select *) and lots of blobs and (n)TEXT types. So lots of data is not in cache and has to be loaded repetetively from storage. Additional the transaction log has been separated from the data files to another drive (Average 800 Mb/s), this was not the case on the old server). Would anyone agree that we can assume this is (besides all your interesting thoughts) the main reason for improvement?