capacity scoping

Question

how to perform a capacity scoping for sql server ?

Answer 1

Create a spreadsheet (maybe one sheet per table):

1. Determine your active tables (i.e. those which are not static)

2. Estimate size of each row in each active table

3. Estimate the Net number of Insertions per unit time period (depends on the level of activity, but per day is usually good)

4. For each active table, multiply the average row size by the Number of Insertions, times the period of time, and add up for each table.