Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Show active queries |
Mon, Apr 29 2019 4:25 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | 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 |
Mon, Apr 29 2019 5:02 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | 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 |
Mon, Apr 29 2019 4:25 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Apr 30 2019 2:30 PM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | 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 |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |