TDS vs. TCP

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

I have 2 SQL 2000 Ent. instance, one is stand alone (test) and the other
instance is on Cluster (production) (W2K3).

I have an application perfomance issue, the application runs ok on test but
it is slow on production. I took a network capture for both instances and
anlyzed the communication between the client and SQL servers.

What I found, when I point the client to test server, I see TDS packets
between the client and Test SQL server but when I point it to production
(cluster), I see only TCP packets (no TDS packest).

Does this make any sense?

Thanks

Ayad


.

Relevant Pages

  • Re: Changing DBID
    ... Server 1 (running production) ... Server 2 ... Client 2 (used for connecting to the copy of the production database ...
    (comp.databases.oracle.server)
  • ASP.NET 1.1 validation client script - confusing difference on different machines
    ... production server - exactly the same code. ... pages has client side validation script, ... But the page from production has client script rendered out like this: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Changing DBID
    ... Server 1 (running production) ... Server 2 ... Client 2 (used for connecting to the copy of the production database ...
    (comp.databases.oracle.server)
  • Re: FBI? MAX? INDEX FULL SCAN (MIN/MAX)?
    ... Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod ... PL/SQL Release 10.2.0.1.0 - Production ... 384 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
  • FBI? MAX? INDEX FULL SCAN (MIN/MAX)?
    ... PL/SQL Release 10.2.0.1.0 - Production ... 384 bytes received via SQL*Net from client ... sorts (memory) ... why use FBI query max)? ...
    (comp.databases.oracle.server)