Posted by Erland Sommarskog on 10/31/07 22:40

Ben (pillars4@sbcglobal.net) writes:
> 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.

Interesting. I have not heard of anything related to packet size before.
Thanks for the update!

--
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

• Next in forum: Re: some error in table definition
• Prev in forum: Re: Millions of Delete Statements
• Thread view: Re: Slow Execution Performance

[Reply to this message]