How can I find out how many user are connected to a Database using EDB Remote Session?

Thanks,
Kim

On 11/20/2019 10:41 AM, KimHJ wrote:
> How can I find out how many user are connected to a Database using EDB Remote Session?

You can find out how many users are connected to EDBServer by using the
system information - ServerSessions table (i.e. query
Configuration.ServerSessions )

https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=ServerSessions_Table

Raul

Raul wrote:

>>You can find out how many users are connected to EDBServer by using the
>>system information - ServerSessions table (i.e. query
>>Configuration.ServerSessions )

>>https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=ServerSessions_Table

Raul,

How will I query it?
I see it in the Elevate DB Manager when I right click the session name and select Manage server sessions.

I was going to use it to restrict how many can login at the same time, but since web app are not connected all the time only when access the data it will not work and the ServerSessions do not have the information about which database the user is using.

I would have to create my own table for each database and keep track, the problem will be if they don't log out, but just close the browser

Thanks,
Kim

On 11/21/2019 1:03 PM, KimHJ wrote:
> How will I query it?

It behaves like a normal table :

"select * from Configuration.ServerSessions"

> I was going to use it to restrict how many can login at the same time, but since web app are not connected all the time only when access the data it will not work and the ServerSessions do not have the information about which database the user is using.

Anybody active with DB operations might have some locks so you could
also query ServerSessionLocks :
https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=ServerSessionLocks_Table

> I would have to create my own table for each database and keep track, the problem will be if they don't log out, but just close the browser

That would probably be most flexible and you can do exactly what you need.

I don't know your usage patterns and logic but this is where you could
look into making the server sessions relatively short lived. See this
article for lot of useful info on this

https://www.elevatesoft.com/articles?action=view&category=edb&article=connections_disconnections_reconnections


Raul

Raul wrote:

>>I don't know your usage patterns and logic but this is where you could
>>look into making the server sessions relatively short lived. See this
>>article for lot of useful info on this

>>https://www.elevatesoft.com/articles?>>action=view&category=edb&article=connections_disconnections_reconnections


Thanks Raul,

We have a web based software that run an a shared cloud server so we want to be sure that each of our customer only connect up to 10 device at the same time for the server to be able to handle the request to the database.

Kim