February 9, 2009 at 12:46 pm
I have a quick couple of questions that I hope someone may be able to answer. For the server settings in SQL Server, I see an option for Packet Size. Also, the packet size exists for OLE DB connections through SSIS from SQL Server.
Question:
1. Is the packet size for both environments related to TDS (Tabular Data Stream) size?
2. Our network sends/receives the default TCP size of 1500bytes, how is the default of 4096 TDS size encapsulated within TCP/IP?
3. By changing SSIS packet size to max 32K, I saw drastic improvement with performance moving data, why is it faster to send large 32K size TDS packets so that TCP/IP must now tear it apart and put it back together? Does this question make sense? I would imagine it would be optimal to send the max size in a TCP buffer instead of the overhead of the jumbo size.
Has anyone had the chance to use SQLNitro? A very simple install that compresses and manages TDS packets?
Thanks
Greg
February 9, 2009 at 12:49 pm
Question?
I wouldn't mess with it unless you have real performance issues or are directed to by PSS. If you have some network issues, or you have set different sizes in your network devices, then you might alter this.
http://msdn.microsoft.com/en-us/library/ms177437.aspx
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 9, 2009 at 1:02 pm
Sorry, I hit reply to quickly, if you read my first thread, it may make more sense.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply