Post reply

Tds Packet Size

  • December 1, 2010 at 8:26 am

    #227678

    I have a problem about tds packet size one client connect to sql server 2008 I run a query and ı gave this results

    avg

    Network Statistics

    Number of server roundtrips11.0000

    TDS packets sent from client22.0000

    TDS packets received from server22.0000

    Bytes sent from client 5054 5054.0000

    Bytes received from server4674 4674.0000

    and then ı run the same query the another client ı got this

    avg

    Network Statistics

    Number of server roundtrips11.0000

    TDS packets sent from client11.0000

    TDS packets received from server11.0000

    Bytes sent from client50465046.0000

    Bytes received from server46664666.0000

    can ı sent any tds packet size in network adapter or sql server 2008 r2 engine.

  • December 1, 2010 at 8:54 am

    #1257447

    http://msdn.microsoft.com/en-us/library/aa174503%28SQL.80%29.aspx

  • December 1, 2010 at 10:27 am

    #1257493

    I set Network Packet size to 12288 but i didn t change anything

    I thinks some setting in client side network adapter or another setting

  • December 1, 2010 at 1:09 pm

    #1257585

    I also set it 1024 and i didnt change too

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply