Find number of concurrent users in sql server 2005

By duncanlarry ·
We have an access based application powered by SQL Server 2005. I am trying to determine concurrent users logged into to the application, using the database, at any point in time.

How can I do this?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

You can find the number of connections

by Tony Hopkinson In reply to Find number of concurrent ...

with SP_Who. and ID greater than 50 is a user.
How useful it is depends on other stuff, such as hoew many connections your app uses, whether you are using connection pooling, whteher you can only have one instance per user and such.

You might get more joy by creating a who's logged in table and just getting your apps to insert / update / delete a record when they start up.

Related Discussions

Related Forums