SQL Server Performance

calculate concurrent users

Discussion in 'SQL Server 2005 General DBA Questions' started by myworld, Sep 27, 2010.

  1. myworld New Member

    for sql 2000 and 2005 how can i check
    1. How many concurrent users per service / application / database - approx size atleast (peak / lean)
    2. db is 32 bit or 64 bit
    thanks in advanced
  2. ghemant Moderator

    you can have a quick view using sp_who2 or can customise the result by querying sysprocesses table
  3. satya Moderator

    1)select db_name(dbid), count(*) from master..sysprocesses group by db_name(dbid)

    2) The database will not be a 32 or 64 bit, it is the instance:DECLARE @value VARCHAR(50)
    EXEC master..xp_regread @rootkey = 'HKEY_LOCAL_MACHINE', @key = 'SOFTWAREMicrosoftMicrosoft SQL Server', @value_name = 'InstalledInstances', @value = @value OUTPUT

Share This Page