The QUERY_EXECUTIONS table has all the information required to analyze a query except memory used. For memory consumption, we need to check the RESOURCE_ACQUISITIONS, which shows the memory consumed for query per node. Is there a way to view the total memory consumed by a query in the QUERY_EXECUTIONS table?
Optimizing Query Performance and Resource Pool Tuning
@rbankula @bat
Question
Monitoring memory usage
+1You could sum it up for all nodes, but I'm not sure how useful that would be. Most nodes should generally have the same memory utilization, unless you have massive data skew.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
