Tag Archives: scom 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

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

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