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.
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.
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.