Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Little help sizing MOM databases....

Status
Not open for further replies.

Giy

Technical User
Mar 8, 2006
1
GB
I currently seem to collect about 10GB of data per day in my MOM database which seems to be a great deal larger than Microsoft seem to suggest I should be generating with just 140 servers monitored with 10 Management packs. They seem to suggest (along with the book Essential MOM by O’ Reilly) that for every machine you should generate 24,000 bytes alerts, 0.5 MB Events and 2MB Performance which added together for one machine is 2.52 MB multiplied by 140 for the amount of agents I have it works out at 352.8 MB which seem quite a lot less than around 10 GB!!

I am looking to setup MOM Reporting and they have estimated that the data will be doubled so I would be generating 20GB going by that standard. They also suggest that the transaction logfile should be 5 or six times the amount of data that is being transferred so going by this the logfile should be about 100GB to 120GB. Which also means that if by default the reporting database is going to be huge as it logs 13 months of data. Someone please tell me I have set MOM up completely wrong or I have done my sums up as the server space I have for log files is 33GB and the database size is 210GB!!! Sizing of databases
 
I will tell you that I run Mom 2k5 as well. I am monitoring a piddly 30 servers and my database grows about 5gb per month. Another 5gb on top of that roughly for the data warehouse aspect with reporting. I am using only 4 MP's as well. I don't think that MS really calculated properly in thier intial documents, and I find that most people have the same issue as well.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top