How to stop not responding query?
Hi
Sometimes I search mesage with inappropriate sql, It caused query hanged long time.
So Is it have way to find these hanged query and kill it?
Tks.
Hi
Sometimes I search mesage with inappropriate sql, It caused query hanged long time.
So Is it have way to find these hanged query and kill it?
Tks.
Depends on how you call it, you can just kill that process which runs such query. If you did it in the System Management portal, wait for a connection timeout, or open a new session in another browser or in incognito mode, go to processes, discover your hanging process, and terminate there.
Yes, I did it in System Management portal, How to find the sql query process?