Post reply

how to find maximum number of concurrent users

  • February 17, 2009 at 1:35 am

    #218566

    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

    #945040

    try sp_who it will give the list of the databases and processes attached with it.

  • February 17, 2009 at 3:48 am

    #945044

    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

    #945054

    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

    #945066

    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

    #945070

    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

    #945073

    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

    #945078

    I got it thank you 🙂

  • June 11, 2014 at 9:34 am

    #1720803

    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