Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Query to get Max no of concurrent users connected

Author  Topic 

vijay1234
Starting Member

48 Posts

Posted - 2014-07-30 : 00:00:12
Hi All,

I would require to know a query that will fetch the max concurrent users connected to the databases in a particular server for a particular month.

Ex:
We have DB's called A,B,C,D ( Excluding sys DB's) in a server called X.

So the max list of users connected to the DB - A,B,C,D for a particular month say 'July'

Result should be like

DB Max No of Users Month
A 10 July
B 8 July
C 45 July
D 76 July

Highly appreciate the response friends.

Thanks & Regards,
Vijay
   

- Advertisement -