Skip to main content

Memorysize in resourcepool

  • October 7, 2014
  • 3 replies
  • 15 views

kambala
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?

3 replies

Nimmi_gupta
Forum|alt.badge.img
  • Participating Frequently
  • October 7, 2014
What's the value of executionparallelism and  plannedconcurrency on both the pool. 

kambala
  • Author
  • New Participant
  • October 7, 2014
plannedconcurrency is 20 on both and executionparalellism is AUTO on both

Raul_1
Forum|alt.badge.img
  • Participating Frequently
  • October 10, 2014
profiling the query should provide some insight.