Archive for July 2007

Estimating Database Sizes

July 26, 2007

When designing a system the question of how much space do I need for the databases always comes up. With MOM 2005 there was a spreadsheet provided my Microsoft to help. For 2007 Microsoft expects you to use System Center Capacity Planner which is still in beta.  As well as not being finished SCCP only tells you the number of drives of a specific size that you need like 3 x 72 GB and not an actual figure. This helps but a real figure would be nice.

Kerrie and Cameron have done some great work to help with sizing the SCOM databases.  http://ops-mgr.spaces.live.com/Blog/cns!3D3B8489FCAA9B51!171.entry. I wrote a post showing how to turn it into a spreadsheet at http://ianblythmanagement.wordpress.com/2007/06/06/database-size-estimation/.

I developed the spreadsheet for my own use and thought that if I find it useful then so would other people so I tidied it up and Pete kindly put it up on System Center Forum.
http://systemcenterforum.org/operations-manager-database-size-estimator/ or you can download it directly at http://systemcenterforum.org/wp-content/uploads/SCOM2007DBestimatorv1.xls.

I have tried to make it simple and easy to use – just put in the number of agents! I have also made sure everything is parameterized so you can alter the assumptions made like the MB/day if you have more MPs or the groom days if you have changed that setting.

DB Estimator

Hope you find it useful.

New Bloggers

July 1, 2007

I was away in Seattle for a week which I will talk about later. I was going to do a June round up but Anders (who has just received an MVP award and well deserved) has already done that – http://contoso.se/blog/?p=182.

I have found some new SCOM blogs recently that I have added to my page of links – http://ianblythmanagement.wordpress.com/mom-blog-links/. There are some good articles in these blogs so worth adding to whatever reader you use.

Monitoring at Microsoft with Operations Manager http://blogs.technet.com/monitoringmicrosoft/default.aspx

Dustin’s Tech Notes (Dustin Hannifin) – http://www.technotesblog.com/

Everything SCOM 2007 – Timothy McFadden http://scom2k7.blogspot.com/

Good ACS stuff at Help Me Manage (Jeff Skelton) – http://helpmemanage.blogspot.com/

Tarek Online! SCOM 2007 in Egypt – http://tarek-online.blogspot.com/ and Tarek is active in the newsgroups.

System Center Operations Manager by Jonathan Hambrook (Australia) http://opsmgr.wordpress.com/

Nice to see more people adding to the SCOM knowledge.


Follow

Get every new post delivered to your Inbox.