SQL Server Performance

TDS and character encoding

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by rjimenez, Aug 30, 2007.

  1. rjimenez New Member

    I've seen a dump of the TDS code going from my webserver to the SQL Server database and it seems encoded in Unicode (it has two bytes per char). Seems it would have a huge impact on performance if it travelled in one byte. Why might this be?
    rj
    rjimenez, Aug 30, 2007
    #2

  2. satya Moderator

    Welcome to the forum!
    Is it states all the time or any particular set of queries?
    Do you get any error?
    satya, Aug 30, 2007
    #3

  3. rjimenez New Member

    Occurs all the time, but no error.
    The problem is that what could be transmitted in a certain amount of bytes, gets doubled.
    rj
    rjimenez, Aug 30, 2007
    #4

Share This Page