Generate a report to check the total number of concurrent users logged to the SQL Server system

• anshul-goyal

  Grasshopper

  Points: 19

  More actions

  August 19, 2008 at 1:41 am

  #125735

  Hi To All,

  I would like to know I have to make a statistics to check the total number of concurrent users logged to the System. I have ran the performance monitor and choosen the "user Connection" counter under SQl Server general statistics.

  Inaddition to this I have also ran a Query " Select * from sysprocesses" to knwo the exact number of users..

  I would like to know is there anything else I can do to find out the best optimum result for finding the number of users concurrently logged.

  Any help for thsi issue would be much apprecaited.

  Thanks

  Ansh

• Richard Fryar

  Hall of Fame

  Points: 3457

  More actions

  September 2, 2008 at 6:43 pm

  #866295

  You could also look at master..sysperfinfo

  This allows you to retrieve the value of some performance counters programmatically.

  
  Check Your SQL Servers Quickly and Easily
  www.sqlcopilot.com

• Maksymilian Mulawa

  Ten Centuries

  Points: 1336

  More actions

  September 3, 2008 at 8:23 am

  #866505

  You can also check out sp_who2

  Cheers, Max

  Check-out free open-source utility Sql Server Replication Explorer[/url]