• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 396
  • Last Modified:

Find out # of concurrent users of a sql 2005 database.

is there a way to find out the number of concurrent users of a sql 2005 database?  If yes, would you instruct how?

We would also want to know the number of users connect to a specific database at a specific date and time.  Is it possible?

Thanks.
0
nav2567
Asked:
nav2567
3 Solutions
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<We would also want to know the number of users connect to a specific database at a specific date and time.  Is it possible?>>
It really depends on your security strategy and connection pooling.  It is very straightforward to map a specific login to a specific database.  Transactions/sec and Batch Requests per sec are usually more used to evaluate database server load.
0
 
shalabhsharmaCommented:
You can use sp_who2, or the Management - Current Activity tool in Enterprise Manager to view connected users.
0
 
Anthony PerkinsCommented:
If you are using any type of connection pooling that may be difficult to get an accurate number using SQL Server.
0
 
nav2567Author Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now