Tag Archives: database

Cleaning out unwanted event collection data from ops database

Most large SCOM management groups have lots of management packs and lots of monitored computers. Invariably this means that there are lots of event collection rules collecting event data and storing it in the Ops database and the datawarehouse. It … Continue reading

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

SQL query to display database sizes

You can ran this SQL query against the Ops DB and the Ops DW to display database size information……. select ‘server’ = @@servername , ‘total size in megabytes’= convert(decimal(10,2),(sum(size * 8.00) / 1024.00 )) , ‘total size in gigabytes’ = … Continue reading

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

Cleaning stale data out of datawarehouse database

Prior to SCOM 2012 R2 UR7, there was an issue whereby SCOM did not groom out old data from the Event Parameter and Event Rule tables in the DW database.This will show up as these tables growing quite large, especially … Continue reading

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

Change the SCOM 2012 Database Grooming Settings using PowerShell

If you want to use PowerShell to change the Database Grooming settings in SCOM 2012, you can use the following: (just set the value to how many days you want to keep the data before grooming it out of the … Continue reading

Posted in Powershell for SCOM, SCOM 2012 SP1 | 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

Addressing database bloat

Database grooming is a well documented topic when it comes to working with SCOM. Only old state change data for monitors that are currently in a HEALTHY state, AT THE TIME that grooming runs are groomed out.  OLD state change events for monitors that … Continue reading

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