SQLPerformance:datavolume over the network per connection?

10 Aug 2006 10:36 PM

mabra

Hi All !

I am trying to find the amount of volume of data each connection is
reading/writing. I initially looked into Perfmon, but it does not have
such counters. I am looking for something like "sp_who/2", which give me
this results. With "sp_who/2" I can get only cpu and memory.

Any help would be really very welcomed!

Thanks so far and
best regards,
Manfred

11 Aug 2006 9:02 AM

Jack Vamvas

Have you looked at the Sessions Event - this will give you some of the
information you require.

----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________

Show quote

"mabra" <mabra@home> wrote in message
news:#mc3q2MvGHA.4384@TK2MSFTNGP04.phx.gbl...
> Hi All !
>
> I am trying to find the amount of volume of data each connection is
> reading/writing. I initially looked into Perfmon, but it does not have
> such counters. I am looking for something like "sp_who/2", which give me
> this results. With "sp_who/2" I can get only cpu and memory.
>
> Any help would be really very welcomed!
>
> Thanks so far and
> best regards,
> Manfred

11 Aug 2006 10:09 AM

Manfred Braun

Hi !

Thanks a lot !

Could you please be so kind and specify this more detailed? I just don't
understand ... ;-)
I looked onto each SQL Server Performance categry, but was not able to find
any counter, which has something like session in it's name. Or do you
possibly mean a special stored procesure/system query?

Thanks,
Manfred
[Just from another account]

Show quote

"Jack Vamvas" <DEL_TO_REPLYtechsupp***@ciquery.com> wrote in message
news:CKadneOUaqkG2kHZRVnytQ@bt.com...
> Have you looked at the Sessions Event - this will give you some of the
> information you require.
>
>
> ----
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> ___________________________________
>
>
> "mabra" <mabra@home> wrote in message
> news:#mc3q2MvGHA.4384@TK2MSFTNGP04.phx.gbl...
>> Hi All !
>>
>> I am trying to find the amount of volume of data each connection is
>> reading/writing. I initially looked into Perfmon, but it does not have
>> such counters. I am looking for something like "sp_who/2", which give me
>> this results. With "sp_who/2" I can get only cpu and memory.
>>
>> Any help would be really very welcomed!
>>
>> Thanks so far and
>> best regards,
>> Manfred
>
>