December 5, 2008 at 7:47 am
Please give me a link or template I can use to do capacity planning & documenting for the same.
I have 4 transactional database & i'm doing the capacity planning for it. I own a data model so i can do it for one. Other databases are owned by a company that gives us the data model but i would have a provide the capacity planning.
Any tool or template would be of great help to plan & document.
Thanks.
December 5, 2008 at 8:20 am
Capacity planning is about knowing the trend in growth over time. You need to monitor how the free space in the data files is changing. I log this information hourly to a table, and I have 2 yrs of history at this point, so I can easily look at trends on a graph. If you'd like to see how I do this, you can look at the source code on this article:
http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=FileSpaceMon
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 5, 2008 at 9:22 am
excellent. this is a good place to start once I move into the production. but, is there any template i can use to justify the capacity planning during the development phase?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply