packet size with sql server 2000 ;

packet size with sql server 2000 ;

Post by svia » Tue, 21 Oct 2003 19:46:31

when should packet size (, sql server) be changed?
we have a application that updates/inserts/deltes a sqlserver 200
database; but we notice that at times; it sems to be pausing betwen
transactions. this behavior is intermittent.

can increasing packet size help? what lese could be the cause of this



packet size with sql server 2000 ;

Post by Billy Yao [MSF » Wed, 22 Oct 2003 06:03:50

Hi Stephane,

It's my pleasure to assist you with your issue.

From your description, I understand that you would like to know whether increasing packet
size will help improve the transactions performance.

However, I need to set your expectation that such random problems are complex to
troubleshoot in newsgroups. You may contact Microsoft Product Support Services via the
following links in case the issue is urgent.;EN-US;CNTACTMS

Based on my research, packet size is a Provider-Specific Connection Parameters that
indicates a network packet size in bytes. The packet size property value must be from 512
through 32767 and the default SQLOLEDB network packet size is 4096.

Increasing the packet size may not improve the performance because it can aggravate the
burden of network communication. For decreasing the network traffic, I think stored procedure
with re-used Execution Plan can be a better choice. Moreover, the Hardware and Operating
System Limitations and the SQL Server Configuration Settings can also be a consideration.

I recommend you look through the following articles for recommendations and apply some
suggestions that meet the needs on your side.

Optimizing Microsoft SQL Server Performance

ADO Performance Best Practices - Get the best performance from your ADO application

319942 HOW TO: Determine Proper SQL Server Configuration Settings

Thank you for using MSDN Newsgroup! If there is anything more I can assist you with, please
feel free to let me know.

Billy Yao
Microsoft Online Partner Support
Get Secure! -
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.


packet size with sql server 2000 ;

Post by Billy Yao [MSF » Fri, 24 Oct 2003 13:15:20

Hi Stephane,

How is this issue going on your side currently?

I understand the behavior was intermittent and it's hard to trace the
problem on your side. I am just writing to see whether the problem is under
control on your side after following the suggestions and workarounds
provided to you.

It seems difficult to address the symptom as it was random, and reproducing
the problem also seems impossible. I'm unsure of what you mean by "pausing
between transactions". Could you specify more or provide more detailed
information? What led you to think it was a pausing problem between
transactions? Can you describe what are those transactions? As many details
as possible will make things clear and help us move closer to finding the

If you have any updates or feedback regarding your experience on this
specific issue, please reply directly to the thread. Your satisfaction is
our #1 priority! Please feel free to let us know if there is anything more
we can assist you with.

Best regards,

Billy Yao
Microsoft Online Partner Support

Get Secure! -
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.


1. Retrieving data from Exchange 2000 server using ado/

I am trying to make an application on a client machine
that will retrieve Outlook Calendar data from a Exchange
2000 Server. I have looked at several ways to do this
(making a webservice on the exchange server, using exoledb
or webdav and so on).

The solution i've found most suitable and interesting, is
using MSDAIPP.DSO as a ADO connection provider to retrieve
information with http:// URL. However I have only seen how
to do this with ADO, not ADO.NET. It is a bit troublesome
to use ADO in .NET and i'm not that familiar with it

Does anyone know if it is possible to use MSDAIPP.DSO in
conjunction with ADO.NET, or if there is some other way to
retrieve data with ADO.NET from Exchange 2000 server? If
so, how is this done?

All help appreciated!

Jan Johansen

2. Update Select Statement Error - Catch rowid..

3. VC++.Net/SQL Server 2000 Personal ed/ADO?

4. Filemaker and Exact Software

5. SQL Server 2000 (Application) Role accessed through ADO.NET

6. US-FL. West Palm Beach Oracle DBA Position

7. SQL Server 2000 and ADO(.net)

8. scptxfr.exe problem

9. Net Packet Size -- ?

10. Newbie needs code pages for SQL Server 2000 access from page using

11. Packet Size on SQL SERVER 6.0