asp.net - Slow DB performance after DB restore on faster server

Question

We have a website running on Windows Server 2008 R2, IIS7, SQL Server 2008 R2 and ASP.NET. We would like to upgrade to a faster server in order to speed up our DB queries.

We have backed up our website data from our old SQL Server and have restored it on our new server. For some reason, the DB performance on the new server is much slower, compared to the old one. This is in spite of the fact, that the new server has 4 times more RAM, a 30% faster SSD and and a 2 times faster CPU compared to the old one. Both servers have the exact same version of Windows, IIS, .NET and SQL Server.

The question is how can a significantly faster server result in slower DB performance? Any input would be appreciated.

Answer 1

Have u configured the indexes and tablespace for indexes. SQL. Server will need some time to generate indexes based on usage patterns. You can test this by running the same query a few times. It should speed up on the same requests. I would assume the speed was attained throughway SQL optimisation.