Posted by Ben on 10/12/07 21:54

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.


"Ben" <pillars4@sbcglobal.net> wrote in message
news:FURPi.1671$LD2.266@newssvr17.news.prodigy.net...
> We recently upgraded our MS SQL Server 2000 to 2005.
>
> Here is what we did:
>
> 1. Perform backup of the database from the old server.
> 2. Created a blank database in the new server.
> 3. Restored the database into the blank database located in the new
> server.
>
> After this process, there was an obvious slowness in the MS Access
> application. Program-wise, I did not do any code changes. The only thing
> that we did was just this upgrade.
>
> I am leaning towards the netwok causing the slowness. But I do not know
> the issues that might slow down the application just because we upgraded
> the same database into SQL 2005.
>

[Back to original message]