SQL Server Performance

counting active users

Discussion in 'General DBA Questions' started by Trev256, Mar 29, 2011.

  1. Trev256 New Member

    how do i count active users? i need to determine whether a database is still active? any other ideas here would also be useful. thanks!
  2. Trev256 New Member

    i forgot to say i need to log this info in a table on a regular schedule.
  3. Trev256 New Member

    u can use sp_who to see logins connected - but i need to count active individual users (not just logins, as could be using a windows group login) - is there any way?
  4. Luis Martin Moderator

    What about:
    sp_who active
  5. satya Moderator

    See the script http://vyaskn.tripod.com/sp_who3.htm from this link, you can setup a scheduled job to run this script save to CSV file, then use SSIS package to pickup that file.
    How frequently and long you need this active users information?

Share This Page