Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pradeep_iete
Yak Posting Veteran
84 Posts |
 Posted - 2010-01-28 : 08:11:27
|
| Hi Friends.I have a Table and firing the query :SELECT * FROM <Table> withTotal 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)',4096sp_configure 'network packet size (B)',16384sp_configure 'network packet size (B)',32767But 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 ? |
|
|
|
|
|
Configuration Values of Network Packet Sizes