Capacity planning

Assuming you know your avg.daily growth rate using a method of your choosing; the numbers for 3 months down the line can be calculated using:

(avg.daily growth*90)*(1+x)-(existing free space in DB)-(existing free space on disk)

Where, x is a fraction indicating how much free space you want to have in your DB when you start planning for expansion. Let’s say you want 10% free on your disk and in your DB then, x is going to be 0.2.


By profession, I’m a SQL Server Database Administrator. I love to poke my nose into different corners and see how stuff looks in there. I keep looking for new things to do as my mind refuses to settle on one topic.

Tagged with:
Posted in general

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: