Posted by Ben on 10/29/07 02:54

An update on this issue, I am still experiencing this slowness problem. I
have tried from executing the maintenance processes, to checking the codes
of the MS Access 2003 application.

One new thing that we found is that if we access the MS Access application
from one of the workstations via remote desktop, the speed is very fast.
So, I do not know what is the relationship between remote desktop, the
network, and SQL Serve 2005 and the application being faster or accessing
the database faster.

Does anyone have an idea?


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99D66F729C5F1Yazorman@127.0.0.1...
> Ben (pillars4@sbcglobal.net) writes:
>> By the way, I noticed one thing:
>>
>> If I run the MS Access in the server computer itself, the slow
>> performance issues are not visible. But then again the hardware has two
>> Intel Quad-Core Xeon processors, 10GB of RAM, and 15,000RPM SATA hard
>> drives. I just wanted to point it out here maybe it tells something. I
>> am still leaning towards network connection problem or ODBC
>> configuration.
>
> If the operation is running decently fast if you have the client on
> the server machine, then it does not seem that the problem is with the
> query execution.
>
> As for ODBC configuration, check that ODBC tracing is not enabled.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]