|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Measuring connection trafficIs 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. -- Show quote____________________________________ 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. __________________________________ "Bojan Kuhar" <BojanKu***@discussions.microsoft.com> wrote in message news:2A6EECAB-B1B8-4310-B482-E710869DD451@microsoft.com... > 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. > > 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. Show quote "William (Bill) Vaughn" wrote: > 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. > __________________________________ > > "Bojan Kuhar" <BojanKu***@discussions.microsoft.com> wrote in message > news:2A6EECAB-B1B8-4310-B482-E710869DD451@microsoft.com... > > 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. > > > > > > > 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. -- Show quote____________________________________ 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. __________________________________ "Bojan Kuhar" <BojanKu***@discussions.microsoft.com> wrote in message news:6F6EC936-C819-44E2-8EFF-16AD37DC199B@microsoft.com... >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. > > > "William (Bill) Vaughn" wrote: > >> 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. >> __________________________________ >> >> "Bojan Kuhar" <BojanKu***@discussions.microsoft.com> wrote in message >> news:2A6EECAB-B1B8-4310-B482-E710869DD451@microsoft.com... >> > 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. >> > >> > >> >> >>  |
|||||||||||||||||||||||
Other interesting topics