Yak Posting Veteran
Posted - 01/28/2010 : 08:11:27
| 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