If you cannot find this, that might be your issue. That is not normal.
What does this return? select * from StandardDataset where SchemaName = 'Alert' If you look at your stored procs in the DW - do you have dbo.AlertProcessStaging ? From: [email protected] [mailto:[email protected]] On Behalf Of Pete Hakesley Sent: Monday, September 5, 2016 10:04 AM To: [email protected] Subject: [msmom] Aleret.AlertStage 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]<mailto:[email protected]> | w: www.scc.com<http://www.scc.com/> a: SCC, CV1, Cole Valley, 20 Westwood Avenue, Tyseley, Birmingham B11 3RZ
