SQL OLEDB packet size connection
Wilfrid
I am running an application with using oledb on a sql2005 server. The server
has default network packet size of 4096.
I set my client to use in the oledb string
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=database;Data Source=server;Packet Size=512
As the client is set to use a PS of 512, will the connection be 512 or 4096?
In other word will the oledb string, in the client, set the PS for the
connection or will it be the serve setting?
Is there a network tool that could also display the PS of an oledb
connection?
thanks in advance for your help
John Bell
The client option should override the server value, this is stated in books
online
e.g.on http://msdn2.microsoft.com/en-us/library/aa196719(SQL.80).aspx
"Client applications can override this value."
John
Erland Sommarskog
> I am running an application with using oledb on a sql2005 server. The
> server has default network packet size of 4096.
> I set my client to use in the oledb string
> Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
> Info=False;Initial Catalog=database;Data Source=server;Packet Size=512
> As the client is set to use a PS of 512, will the connection be 512 or
> 4096?
As I recall, 512. 4096 is the default packet size which the client can
override.
> In other word will the oledb string, in the client, set the PS for the
> connection or will it be the serve setting?
> Is there a network tool that could also display the PS of an oledb
> connection?
You can see the packet size in the DMV sys.dm_exec_connections. To see
the packet size for you current connection:
SELECT net_packet_size FROM sys.dm_exec_connections WHERE spid = @@spid
--
Erland Sommarskog, SQL Server MVP, esq...@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