Network Packet SIze

microsoft.public.sqlserver.server

19 Jan 2006 9:10 PM

skg

We have following connection string in ado.net application.
The Packet Size is set to 32767.

public string dbConnString =
"Server=SQLServerName;Database=SQLDB;UID=dbUser;PWD=Passwrod1;Packet
Size=32767;Pooling=true";

We do lot of bulk inserts using using this application.

Also this property is available at SQL server level as network packet size
(B) if we do sp_configure.

Does setting this property at the connection level is sufficient for better
performance of bulk inserts or it needs
to be changed at server level since bulk inserts involve accessing network
files which is unrelated to connection with client.

TIA