Post reply

Can I analyze the previous 4 months database growth

  • May 11, 2011 at 3:25 am

    #250157

    Can I analyze the previous 4 months database growth and predict the next 2 years database size will be?

    Some times we had to answer to client.I know its strange but Can it be?

    Thanks

  • May 11, 2011 at 3:36 am

    #1322816

    I do this, but it's not done for you in SQL Server. I capture mdf,ldf and data sizes every day - from this I produce reports on database growth and as I have several years of data I can then forward predict growth for trending, I currently predict 3 years ahead.

    so - create a table to collect the data, schedule a job and write some reports. as they say in Meerkovo "simples!"

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply