Posted by Greg D. Moore \(Strider\) on 10/13/07 13:39

"Ben" <pillars4@sbcglobal.net> wrote in message
news:T%RPi.1672$LD2.1355@newssvr17.news.prodigy.net...
> The hardware configuration below:
>
> - Has two Intel Quad-Core Xeon processors
> - 10GB of RAM
> - 15,000RPM SATA hard drives
>
> The old server was just a regular P4, 4G RAM.
>

Did you update stats on the restored DB?

If not try that. The query optimizer may be making bad choices based on
information gleaned from the old hardware.


--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]