SQL- TDS - TCP/IP questions.

Hi, does anyone know how to explain how SQL transactions get mapped into TDS and TDS gets mapped into TCP/IP packets?


Or can you please point me in the right direction? I need to figure out how TDS and TCP/IP relate?

We're using replication and are having some latency issues and I'm trying to find out how SQL handles TDS and TCP/IP etc...

Thanks for your time.

You should check network issue at os level.

Thanks, I will take a look. Is this an automatic thing with sql using TDS? Is it code related as to how it uses TDS?

What's TDS anyway?

TDS is this...

http://msdn2.microsoft.com/en-us/library/ms191220.aspx

I'm trying to find out if there are any know issues with this regarding latency and replication.

Don't have to worry about those internals. Things you like to check are disk i/o, cpu usage and network traffic in this case.

OK, thanks.