5 Replies Latest reply: Jun 17, 2014 2:23 PM by TimG RSS

    Why does it take multiple agg statements to reach stable page size?

    user616364

      I'm running a calcscript to aggregate the aggregating sparse dimensions in a database.  I have to run the agg statement 5 times before the page file stops growing.  I checked the database properties.  The number of blocks doesn't change.  The clustering ratio changes, but sometimes it goes up and sometimes it goes down.  Can someone help explain what is going on?  If the number of blocks isn't changing why is the page file growing?

       

      The agg statement looks like this:

      AGG ("Dimension 1","Dimension 2","Dimension 3");