Post reply

how to find Avg and Max concurrent users connecting to a database?

  • March 10, 2016 at 12:59 pm

    #325618

    Hi,

    I'm trying to find the the avg and max concurrent users connecting to a sql instance and to a particular database.Please advise how to get that information.

    1.How many average concurrent users are connecting to SQL server instance ?

    2. How many average concurrent users are connecting to a particular database?

    3.How many max concurrent users connecting to SQL Server instance?

    4. How many max concurrent users connecting to a particular database?

    Thanks

    Gary

  • March 10, 2016 at 2:13 pm

    #1864402

    This looks like a good place to start: http://www.sqlfingers.com/2014/02/total-number-of-activeopen-sql-server.html

  • March 13, 2016 at 10:14 pm

    #1864834

    is there way to find concurrent users connecting to a particular database?

  • March 15, 2016 at 3:13 pm

    #1865474

    gary1 (3/13/2016)

    is there way to find concurrent users connecting to a particular database?

    Did you check the link Jon posted?

    If you did, then please post what you have right now and show us which specific piece you are stuck at.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

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

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