Amount of Data

Amount of Data

Post by Russ Holco » Wed, 14 Jan 2004 01:21:50


Is there a way to determine how much data is being moved to and from SQL
Server 2000? We are 3 tier and want to charge by bandwidth.

Thanks

Russ
 
 
 

Amount of Data

Post by Mike Colli » Wed, 14 Jan 2004 12:08:40

Russ,


*If* your middle tier contains the old Borland Midas componet
TSocketConnection, then I believe their is a way of measuring bytes
sent/received. It's been a long time since I played with it though..

--
Mike Collier
http://www.yqcomputer.com/
http://www.yqcomputer.com/

 
 
 

Amount of Data

Post by Russ Holco » Thu, 15 Jan 2004 06:25:53

We are using the "old midas TSocketConnection". What is your preferred 3
tiered architecture?

Russ
 
 
 

Amount of Data

Post by Mike Colli » Fri, 06 Feb 2004 20:14:55

> We are using the "old midas TSocketConnection". What is your preferred 3

For me it depends entirely on what I'm doing at the time, and the
environment a new system would have to run within.

TWebConnection can be handy because of port 80 availability, but not all
machines have web servers running.

TDComConnection requires knowledge of DCOM configuration (and this seems to
change with each new version of windows).

TSocketConnection is easy to setup and has the advantage of being able to
compress and encrypt (and in your case measure) the data. I tend to use
TSocketConnection by default - if I am using MIDAS.

With ADO you don't need to use TClientDatasets with the MIDAS components, so
I use a mixture of various other techniques too (SOAP wasn't too dificult to
get working).

I'm currently looking at C# Builder and web services since these will lead
the way for future designs (I expect).

--
Mike Collier
FREE ADO Inspector tool when you register at ADO forum.
www.adoanywhere.com
http://www.yqcomputer.com/








SQL


SQL