Posted by Erland Sommarskog on 11/02/07 22:08

Ben (pillars4@sbcglobal.net) writes:
> I just had to ask cause I wanted to know your input on that. I am still
> in the observation state. Personally, I have always set the settings to
> default unless it is really, badly necessary to change it. As I did
> with SQL Server 2000. That is why I did not think of the packet size
> that it needs tweaking. In SQL Server 2000 the packet size was set to
> zero. I am assuming that this was the default value, which meant that
> the packet size will grow or shrink as needed by SQL Server 2000. I
> checked the setting in SQL Server 2005 and the default was 4 KB. Looks
> like they changed it indeed.

I looked on two SQL 2000 instances, and they have a network packet size of
4096, and as I recall this is also default. Also, according sp_configure,
the minumum packet size is 512, not 0. I have never heard of any dynamic
packet size. It is however for an application to require a different
packet size when it connects.

Maybe someone did a tweak to the packet size on your SQL 2000 a long time
ago, and no one no longer recalls that it ever happened.

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