locked
Azure Analysis Services Processing Issue - Taking Long time between Start Processing Partition and Reading Data step RRS feed

  • Question

  • Hi All,

    We have azure analysis services (S4; 200GB RAM), we are in the processing testing processing times between On-Prem vs AAS so we are just processing 60M records tables in AAS (On-Prem processing table ~15mins) which is taking around 40mins. I turned on the sql profiler to see what is happening, from there i came to know it is taking more than 25mins between these 2 steps - "Started processing partition" and "Reading data for the Partition". This is just the straight select on top of the table, no logic involved. The whole 200GB is free nothing is running other than this cube. 

    When i process small table which has less than 10M rows, then it is not taking more time between the above 2 steps. 

    Any help would be greatly appreciated!!

    Thanks!


    • Edited by Praveen Y Tuesday, August 4, 2020 1:43 AM
    Tuesday, August 4, 2020 1:43 AM

All replies