Measuring connection traffic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way of measuring traffic on the SQL connection? I have a Windows
Forms app connecting to SQL 2000. I'd like to how much traffic certain parts
of the app are generating.
 
Check out the SQL Server Performance counters exposed programmatically or
via PerfMon.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
I have. I couldn't find what I am looking for. Maybe you can suggest which
counter I should use.

I am not interested in speed, memory used, cpu cycles etc. at this point,
all I want to know is amount of taffic generated by a "unit of work".

Maybe I should use a protocol analyser on my network connection.
 
I'm not sure either. I would re-ask this question on the
microsoft.public.sqlserver.server newsgroup. A protocol sniffer would
certainly tell the tale though.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top