SQL Server Performance

calculate concurrent users

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

  1. myworld New Member

    Greetings,
    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
    myworld, Sep 27, 2010
    #2

  2. ghemant Moderator

    you can have a quick view using sp_who2 or can customise the result by querying sysprocesses table
    ghemant, Sep 27, 2010
    #3

  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
    satya, Sep 30, 2010
    #4

Share This Page