Re: Speed Issue After Upgrade
- From: Ed Murphy <emurphy42@xxxxxxxxxxxx>
- Date: Sat, 13 Oct 2007 20:20:54 -0700
Ben wrote:
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.
Can you run the application on the database server itself, as a
diagnostic? This should take the network out of the equation,
and thus point out whether or not it is at fault.
.
- References:
- Speed Issue After Upgrade
- From: Ben
- Speed Issue After Upgrade
- Prev by Date: Re: Speed Issue After Upgrade
- Next by Date: Increasing performance of ReportServer - ChunkData table
- Previous by thread: Re: Speed Issue After Upgrade
- Next by thread: Increasing performance of ReportServer - ChunkData table
- Index(es):
Relevant Pages
|
