In my environment, the shortest run query (2 mins) has the highest memory consumption (+100GB). Should I be concerned about that?
@bat @rbankula
Question
What are some guidelines for measuring query performance for my environment?
+2When queries consume 100+ GB it is most likely doing may additional acquisitions to build hash table require for join or group by. You can try some of the tips and tricks from today presentation to analyse this and make possible optimizations .
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
