Hi Kevin, Thanks for the response
I had checked the dataset and it is there SchemaName Alert DataSetID A9FD..... Also yes in my stored procedures I have a dbo.AlertProcessStaging My Alert.AlertStaging row count is currently 111,577,637 !! 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 From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Holman Sent: 05/September/2016 17:13 To: [email protected] Subject: [msmom] RE: Aleret.AlertStage 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]> [mailto:[email protected]] On Behalf Of Pete Hakesley Sent: Monday, September 5, 2016 10:04 AM To: [email protected]<mailto:[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
