Hi Team,
Is there a way we can find if the query which is active for so long is progressing at all or not?
We see some sessions/queries active in the query_requests/sessions but not really sure if they are moving or just a stale connection which is stuck to close the session.
Do we have any easier way to find if the query is moving or not?
+2There are a few system tables you could check based on transaction ID and statement ID, for example:
resource_acquisitions (getting new resources?)
resource_queues (waiting for resources?)
execution_engine_profiles (what is it doing now?)
vs_plan_activities,vs_plan_activity_details (like EE profiles but finer-grained)
+2Hi Bryan_H, can you provide an example of using execution_engine_profiles? I'm looking at an example query and find there are ~32k rows related to it.
It's very difficult to determine what is going on.
Thanks
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
