Post reply

Server Properties: Packet Size

  • February 9, 2009 at 12:46 pm

    #130793

    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

    #940748

    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

  • February 9, 2009 at 1:02 pm

    #940761

    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