Memorysize in resourcepool

kambalakambala
in General Discussion
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?

Comments

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...