+1Is there a way to restrict the amount of memory a single query can consume?
For example, say I have a resource pool with a number of queries running and everything works well - but then occasionally a query shows up with a lot of joins and chews up 120Gb of RAM by itself. This ends up starving everything else in the pool. Is there a way to restrict how much that single query can get without modifying the overall resource pool values?
+2
This might not be what you want but you can set the MAXQUERYMEMORYSIZE in the resource pool if you are at 9.1. It was designed to help with what you are talking about.
+1That sounds perfect. Where is it? I don't see anything even remotely close to that in either confguration_parameters or vs_configuration_parameters.
+2It is a resource pool parameter.
+1Apparently I need to upgrade my sandbox. Looks like they added this in 9.1. That's cool. Sounds like yet another for Domo to upgrade.
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
