All, I have a very large Alert.AlertStage table >500GB
I have decided that truncation is the simplist method to resolve this however. |Following various articles some as to disable the DW maintenance rule for alert dataset. However, I cannot find this dataset in the DataWarehouse rule Question is this dataset now been removed for override? Also every time I truncate the table it just fills with 100K's or rows of data and fills the dataset. Can anyone help. Ps. SCOM 2012 R2 UR9 and I do not get any errors in the Operations Manager Logs on any of my MS servers? e.g. a. Disable Alert Dataset maintenance rule from Operations Console. Go to Authoring pane-> Expand Management Pack Objects-> Select Rules Scope the Rules to "Standard Data Set" (use View All Targets option). Now we will see a rule called "Standard Data Warehouse Data Set Maintenance Rule". Override for a Specific object -> select "Alert Data Set" and save it in any Unsealed MP. Peter Hakesley | Monitoring & Automation Technical Lead Engineer, Data Centre Services t: +44(0)845 155 6556 ext: 4006 e: [email protected] | w: www.scc.com<http://www.scc.com/> a: SCC, CV1, Cole Valley, 20 Westwood Avenue, Tyseley, Birmingham B11 3RZ
