Tag Archives: opsdb

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

Who was the last person to modify SCOM roles?

It might be useful to periodically keep track of changes made to the Security-User Roles section of SCOM. You are going to know who you have given the ability to make modifications, but it is not quite as easy to see which … Continue reading

Posted in 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