May 25, 2012 at 5:24 am
good Day. We were used to build an sql server and space is never an issue , but lately this bubble has burst and I would like to know if there is a reliable method to estimate database growth and future estimates . Any ideas ?
May 25, 2012 at 5:35 am
Historical trends and extrapolation can get you a reasonable idea. Otherwise chat with business and see how they see business expanding over time and use that along with your knowledge of what you store to work out how the sizes may change.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2012 at 5:35 am
This should get you on the right track:
http://msdn.microsoft.com/en-us/library/ms187445.aspx
-- Gianluca Sartori
May 25, 2012 at 5:59 am
Have you been monitoring and recording disk space utilization for the past duration of time? If so, you can use this as trend analysis and see where that is going. A faily accurate method, and probably your best bet.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply