Posted by Ben on 10/31/07 20:44

The main problem in this issue was the packet size. The packet size setting
of SQL Server 2005 required it to be increased. So, after the update
statistics and reindexing, the packet size just had to be increased and that
solved the slowness problem.


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99D85ED284201Yazorman@127.0.0.1...
> Ben (pillars4@sbcglobal.net) writes:
>> 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?
>
> Maybe you should involve people in the Access forums as well in case this
> is
> an Access issue?
>
> Given the low level of information you have provided, there is not really
> much more to say from the SQL Server side. But I would recommend that you
> investigate he query plans, and confirm that they are identical in all
> cases.
>
> --
> 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]