SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

pradeep_iete
Yak Posting Veteran

India
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  
 New 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.05 seconds. Powered By: Snitz Forums 2000