Memorysize in resourcepool

Memory size for pool1 is 10% and pool2 is 20% and maxmemorysize for both is 90%. When run using an user in pool1 the query takes less time than the same query run with user in pool2. Shouldn't the pool2 query run faster coz its initial memory is higher than pool1? If 2 queries are run in parallel from one pool will the memory allocation be half the actual size?


  • Options
    Nimmi_guptaNimmi_gupta - Select Field - Employee
    What's the value of executionparallelism and  plannedconcurrency on both the pool. 
  • Options
    plannedconcurrency is 20 on both and executionparalellism is AUTO on both
  • Options
    profiling the query should provide some insight. 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file