Estimating Table Size using Excel

• AZ Pete

  Say Hey Kid

  Points: 672

  More actions

  April 3, 2015 at 4:34 pm

  #99993

  Hi All,

  I'm building a spreadsheet to estimate table sizes for a data warehouse (or any DB).

  I'm using a Microsoft MSDN article for the method on how to do the computation and have run into a snag in how to perform a certain computation in Excel.

  According to the article, the formula to compute the Number of Index Pages is:

  Num_Index_Pages = ∑_Level (Num_Leaf_Pages / (Index_Rows_Per_Page^Level))

  where 1 <= Level <= Non-leaf_Levels

  (Step 2.8 from here: https://msdn.microsoft.com/en-us/library/ms178085.aspx)

  I've computed the Num_Leaf_Pages and Index_Rows_Per_Page, but don't know how to do the summation computation in Excel. Does anyone know the Excel function that can be used to perform this calculation?

  Thanks!

  Peter