Is there any possibility in elevatedb to show all active queries on edbmanager for all sessions?
Sometimes we need to stop active-queries because of problems and we don't see them.

Yusuf Zorlu
MicrotronX

i.e. sometimes users create their own scripts, one user runs a


select * from table1, detail1
where table1.id=detail1.masterid

and the server starts doing this ... and goes >30% cpu and can't response to other sessions from other computers.
It is also not possible to have a "select * from configuration.serversession" to see or remove a session doing this "false" query to db with where join ... only possibility is to close all clients, close all session.

STOP the db-server-service and restart it!

We need a solution for this, having customers with >80 clients per db on different locations so it is not possible to inform all users to close their clients .... We need something like "show active queries" and "cancel query with id"

If possible asap. Thanks.

Yusuf Zorlu
MicrotronX

Yusuf,

<< Is there any possibility in elevatedb to show all active queries on edbmanager for all sessions? >>

No, it's just not possible, given the current architecture of EDB.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<< No, it's just not possible, given the current architecture of EDB.

Ok. Thanks. So we'll create something on our side.

Yusuf Zorlu
MicrotronX