client statistics

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 1

[font="Courier New"]Hi,

You can use the below query to check it

select * from sys.dm_exec_connections

In the output search for num_reads & num_writes columns for the SPID . The output will be one row for each SPID.[/font]

ankur.sharma235-703357 SSC Rookie Points: 37 More actions · Answer 2

hello,

i m executing the same on the querry analyzer. it gives me an error : Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'sys.dm_exec_connections'.

thank u

ankur.sharma235-703357 SSC Rookie Points: 37 More actions · Answer 3

SSC Rookie

Points: 37

April 9, 2008 at 12:34 am

i am using sql server 2000.