Arthur Fuller
fuller.artful at gmail.com
Wed Mar 18 04:09:05 CDT 2009
My understanding is that increasing the packet size is most beneficial if you are working with LoBs such as graphics or XML data. Larger packets mean fewer round trips. For "normal" data there is not much gain, if any. A. On Wed, Mar 18, 2009 at 4:31 AM, Gustav Brock <Gustav at cactus.dk> wrote: > Hi Francisco > > That is SQL Server. > However, I managed to get it working. I started from the Configuration > Manager the SQL Server Browser and that made a difference. > > By the way, SQL Management Studio defaults to a packet size of 4096 while > when you create connections from within VS the default is 8000. > Do you know what is to prefer and must these match? > > /gustav >