February 17, 2009 at 1:35 am
Hi,
I need to find maximum number of concurrent users of each database.
Could anyone help me with that please ?:)
February 17, 2009 at 3:36 am
try sp_who it will give the list of the databases and processes attached with it.
February 17, 2009 at 3:48 am
You can work in 2005 management studio >Management>Activity Monitor and in 2000 Management>current activity >Processinfo.
also you can use sp_who
February 17, 2009 at 3:59 am
thanks for the comments 🙂
but activity monitor and sp_who displays number of currently connected users, right?
isn't there any way to get the maximum number of users generally? or I have to execute sp_who now and then and guess a number totally?
February 17, 2009 at 4:16 am
In activity monitor you have a cloumn status which would says runnable this means the user is active at present and doing some action.
February 17, 2009 at 4:25 am
Then you mean I have to check activity monitor once and hour and count the number of connected users then calculate an average amount of that to get an idea about general maximum number of users of each database, right?
February 17, 2009 at 4:33 am
If you need to gather specific information of user over specific time best option would be create and run a trace.otherewise you could follow the previous post.
February 17, 2009 at 4:39 am
I got it thank you 🙂
June 11, 2014 at 9:34 am
SQL 2008 +
I found this, I am looking for a better way however.
USE MASTER
GO
EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'user connections'
EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE
GO
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply