Tracing the client connectivity on sqlserver 2005

Question

Post reply

Tracing the client connectivity on sqlserver 2005

sram24_mca

SSCrazy

Points: 2633
More actions
April 15, 2008 at 12:21 am

#124864

Hi guys,
I have a doubt to trace out the client connectivity on server.
I want to know,how many clients are connecting to one particular server
Can anyone give me ideas

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

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

dbaker-620086 SSCrazy Points: 2336 More actions · Answer 1

suggest that you first try these commands in a query

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

select A=count(*) from master..sysprocesses

select B=count(distinct hostname) from master..sysprocesses

select C=count(*),hostname from master..sysprocesses group by hostname order by hostname

or these (same results but may be preferred in some camps)

select D=count(*) from master.sys.dm_exec_connections

select E=count(distinct client_net_address) from master.sys.dm_exec_connections

select F=count(*),client_net_address from master.sys.dm_exec_connections group by client_net_address order by client_net_address

HTH

Dick

sram24_mca SSCrazy Points: 2633 More actions · Answer 2

Hi,

Thanks for your valuable answer.

Thanks in advance

Ram.

Atif Hall of Fame Points: 3578 More actions · Answer 3

AOA

You may use dos command "net file" in command prompt.

It will give you the list that how much connections are there to your server. Among them you may get count for query pipe connections.

TC

DBDigger Microsoft Data Platform Consultancy.

Johan Bijnens SSC Guru Points: 134873 More actions · Answer 4

- keep in mind "hostname" is data the client needs to provide.

- with e.g. access, when creating a linked table, it keeps the hostname data that has been provided by the dsn at link time. (so that is hardcoded ! even if you execute it from other clients!)

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me