Operations Manager Datawarehouse Full
-
Thursday, April 05, 2012 3:48 AM
Hi All
3 years before we have installed SCOM DW in 1 TB harddisk. Now we have reached 95% of disk space. as of now we have only 50 GB free space , before something goes wrong we need to take immediate action on this .
Can anyone help me how to solve this issue . we want to know what details stored in DW and waht data's we can remove from DW
Please help us
All Replies
-
Thursday, April 05, 2012 4:36 AMModerator
Hi
This is a great article from Kevin Holman on the data warehouse on what is stored there and how to go about grooming data out:
There is another thread here that might help:
Cheers
Graham
Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/- Marked As Answer by Graham DaviesMVP, Moderator Saturday, April 14, 2012 7:52 AM
-
Thursday, April 05, 2012 12:45 PM
Hello,
There are reports helpful in this scenario:
1st report: Reporting >> Microsoft Data Warehouse Reports >> Data Warehouse Properties
This report will show you data volume per data set (Performance / State / Alerts / Events)
2nd report: Reporting >> System Center Core Monitoring Reports >> Data Volume by Management Pack
This report will show you the Data Volume by MP utilization, so you can identify which management packs are consuming space and by drill in the report you can identify the noisy servers/objects/instances which are causing huge amount of DW data..
Hope it helps..
Regards,
Mazen Ahmed
- Edited by Mazen AhmedMicrosoft Employee Thursday, April 05, 2012 12:47 PM
- Marked As Answer by Graham DaviesMVP, Moderator Saturday, April 14, 2012 7:52 AM
-
Thursday, April 05, 2012 4:23 PM
Hi
My company has also deploy SCOM solution with ~300 servers for more than 2 yeras. The datawarehouse size is appro. 150GB.
- check how much unallocated space of datafile by using following tsql statement(exec sp_spaceused)
- If unallocated space is less than 10%, you may use dwdatarp.exe to view retention setting and size of DW.
- download the tool from http://blogs.technet.com/b/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx
- command to view retention setting and size of dw : dwdatarp.exe -s servername -d OperationsManagerDW
3. use dwdatarp.exe to modify the retention setting
- For detail, pls. refer to the blog: http://blogs.technet.com/b/kevinholman/archive/2010/01/05/understanding-and-modifying-data-warehouse-retention-and-grooming.aspx
Roger
- Marked As Answer by Graham DaviesMVP, Moderator Saturday, April 14, 2012 7:52 AM
-
Saturday, April 14, 2012 7:52 AMModerator
Hi
Hopefully the responses answer your question - if not, or you have further questions, please feel free to reopen the thread and we'll continue to assist.
Regards
Graham
Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/ -
Tuesday, October 02, 2012 11:31 PM
FYI this tool doesn't "really" work for OM12... In OM12 we have additional tables that you can assign a retention policy that the SCOM 2007 version of this tool will not pickup or report on, APM for instance.
.png)
