Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Evicted Dataset location

I am little confused with this whole eviction scenario. I have Premium P1 license, so RAM alloted is 25 GB. Say I refresh 5 datasets each of size 5 GB, does all these 5 dataset reside in RAM. If I then start the refresh of another dataset, I assume one of the dataset proccessed for the first time gets evicted. After eviction does it reside in the hard disk of the server? I mean what happens if a user tries to run a report against this evicted datset, will he/she have any performance impact?

General Comment

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi folks any input is appreciated.

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous，



    From my understand, if you refresh 5 datasets each of size 5 GB, all these 5 dataset will not reside in RAM at the same time. RAM will automatically allocate resource space according to some rules. 

     

    In addition, if one of the dataset proccessed for the first time gets evicted, it will not reside in RAM, so there will be more cache space, then if there is another refresh, the performance will be better as it has more space.

     

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      So when the evicted dataset is refreshed again, does it again go to the RAM?

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi Anonymous,

         

        Yes.

         

        Best  Regards,

        Cherry