Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Configuration Values of Network Packet Sizes
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

84 Posts

Posted - 01/28/2010 :  08:11:27  Show Profile  Reply with Quote
Hi Friends.
I have a Table and firing the query :

SELECT * FROM <Table> with
Total Rows : 68603904.

Actually i was trying to see the number of records that has been fetched in sampled time of 2 minutes for different values of following configurations.

sp_configure 'network packet size (B)',4096
sp_configure 'network packet size (B)',16384
sp_configure 'network packet size (B)',32767

But i see invariably same number of records fetched.In other words not much impact has been observered considering various configurations for "network packet size".Please elaborate on that and correct me where ever needed?
Is sp_configure 'network packet size (B)' worth Consideration for getting more records comparetively ?

Edited by - pradeep_iete on 01/28/2010 08:12:18
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000