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?
  2. satya Moderator

    Welcome to the forum!
    Is it states all the time or any particular set of queries?
    Do you get any error?
  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.

Share This Page