Network Packet Size: to Fiddle With or Not to Fiddle With

A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s something that DBAs should be aware of. There is a server configuration in SQL Server that controls the size of packet in which SQL Server sends out data. This setting is called network packet size (B). Yet another size we need to know about in SQL Server. As DBAs, we tend to think of size in terms of 8K pages
read more