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

• Next in forum: Re: Speed Issues After SQL Upgrade
• Prev in forum: Re: Would special character cause insertion problem?
• Thread view: Re: Speed Issues After SQL Upgrade

[Reply to this message]