Networks

Ask something
Question Locked

Find number of concurrent users in sql server 2005

0 helpful
2 replies

by duncanlarry

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

2 replies

by tony hopkinson

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.

This discussion is closed to new replies.