Tag Archives: datawarehouse database

SQL Query to report on how many times a particular alert has triggered

Here is a very useful SQL Query that you can use to determine how many times a particular alert has fired, when it fired and what host it fired on. Open up Microsoft SQL Server Management Studio on your Datawarehouse … Continue reading

Posted in SQL Queries | Tagged , , , , , , , , , , , | Leave a comment

SQL requirements for SCOM

Below is a doc that outlines SQL Server 2008 R2 High Level Requirements when installing a new SCOM management group. It covers topics like:-estimated IOPS, maintenance plans, recovery models and changing the grooming settings on the datawarehouse database. SQL and SCOM … Continue reading

Posted in Misc Stuff | Tagged , , , , , , , , , , , , , , | Leave a comment

SCOM Database Grooming

THE OPERATIONS DATABASE The Operations Manager database keeps data for a period of 7 days by default, these settings can be adjusted in the console as follows:- In the Operations console, click Administration. In the navigation pane, expand Administration, and … Continue reading

Posted in Misc Stuff | Tagged , , , , , , , | Leave a comment