DB先快后慢DB的性能更快的服务器上恢复 [英] Slow DB performance after DB restore on faster server

问题描述

我们有Windows Server 2008上运行一个网站R2，IIS7，SQL Server 2008 R2和ASP.NET。我们想升级到更快的服务器，以加快我们的数据库查询。

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.

我们已经从我们的旧的SQL Server备份我们的网站数据，并恢复了它我们的新的服务器上。由于某些原因，在新服务器上的数据库的性能要慢得多，相比于旧的。这是尽管事实上，新的服务器有4倍以上的内存，更快的30％，SSD和和2倍速度更快的CPU相比老款之一。这两种服务器有Windows，IIS，.NET和SQL Server的版本完全相同。

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.

问题是怎么能显著更快的服务器导致较慢DB的性能？任何投入将是AP preciated。

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

推荐答案

我们已经找到...在服务器上的电源设置设置为平衡的问题。我们已经将其设置为高性能和DB快得多现在

We have found the problem... the "Power settings" on the server was set to "Balanced". We have set it to "High performance" and the DB is much quicker now

很抱歉给您带来不便

这篇关于DB先快后慢DB的性能更快的服务器上恢复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！