Microsoft gives guidance for calculating the estimated sizes of your tables and indexes at http://msdn.microsoft.com/en-us/library/ms175991.aspx. Performing such estimates is an important step in determining required server capacity.
Unfortunately, Microsoft’s guidance consists of long textual descriptions of the steps that need to be followed to perform the estimations. It takes some time to interpret the instructions given by Microsoft and perform the calculations.
With that in mind, I put together a spreadsheet to help me perform the calculations. To use the spreadsheet, I simply fill out the spreadsheet with the total number of rows in the table and details of the columns (data types and sizes) in the table and/or index. In my experience, the estimates provided by the spreadsheet are within 5-10% of the actual sizes of the tables/indexes, which has been good enough for my needs.
You can download the spreadsheet here.
To complete the spreadsheet, simply…
View original post 221 more words