Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

This may be a really stupid question, but...

The TDS protocol used by sql server appears to use unicode or UTF-16 character encoding. A query like select foo from bar appears like s.e.l.e.c.t. .f.o.o. .f.r.o.m. .b.a.r in the tcp stream in wireshark.

If you have an application connecting to SQL server over a network, that absolutely does not and probably never will use unicode text fields, is there a way to tell the sql client to encode the queries in ascii to cut network traffic?

share|improve this question

2 Answers 2

up vote 2 down vote accepted

The tabular data stream (TDS) protocol documentation specifically states that SQL statements in the protocol will be encoded in Unicode (section 2.2). Unless you're running over a heavily bandwidth-constrained network you're probably just gold-plating to worry about this. (If you are bandwidth-constrained to the point that this is a problem you might want to consider tunneling the traffic over something with compression.)

share|improve this answer
    
Thanks, that link is really handy. –  simon Aug 1 '11 at 13:06

I have just found this which seems to do some sort of compression on sql server tds traffic:

http://www.nitrosphere.net/store/nitroaccelerator

My initial test have shown that it works very well but it is quite expensive.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.