-
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?
-
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|