SystemCenter

All about System Center Articles and Tutorials

Fixing SCOM DB Fragmentation issue

Posted by on Aug 29, 2016 in SCOM 2012, SQL

Fixing SCOM DB Fragmentation issue

Sometimes, when I am using a development or test environment and I run into a situation where SCOM is taking more time to generate the report, SCOM console slowness or the queries in SQL is behaving slower than normal, first thing I want to rule out is “Do I have any fragmented indexes?”. Fragmentation is an element that has been critical to SQL Server performance for many years. As data is...

Read More

Reset SCOM Unit Monitors in Bulk

Posted by on Aug 23, 2016 in PowerShell, SCOM 2012

Reset SCOM Unit Monitors in Bulk

Recently someone asked me if there’s any possibility to reset all the Unit Monitors in Bulk as resetting the individual monitors that don’t recalculate automatically is really a tedious task. I checked few of the unhealthy servers in their SCOM environment and found there were monitors sitting in unhealthy state and there was not any open alert corresponding to those unhealthy monitors in the...

Read More

SQL Server 2014 SP1 CU8 Released

Posted by on Aug 19, 2016 in SQL

SQL Server 2014 SP1 CU8 Released

Microsoft has released the Cumulative Update 8 (CU8) for SQL Server 2014 SP1 on 15th August 2016. This update contains the fixes for issues that were fixed after the release of SQL Server 2014 SP1. This Cumulative Update includes all the fixes from all previous SP1 Cumulative Updates, therefore it can be installed to resolve issues fixed in any previous SP1 CU. The Cumulative update can be...

Read More

List of SCOM Management Servers and Agents

Posted by on Aug 17, 2016 in PowerShell, SCOM 2012, SQL

List of SCOM Management Servers and Agents

Many a time our management asks me to send the list of all SCOM Management Servers and Agents so they can showcase the numbers in their presentations. Obviously it’s not a rocket science to get the list of Agents and Management Servers in SCOM environment. Anyone having administrative access on SCOM environment can get the list. You can fetch the list of all your Management Servers and Agents...

Read More

Modify SCOM Data Warehouse Retention Policy

Posted by on Aug 16, 2016 in SCOM 2012, SQL

Modify SCOM Data Warehouse Retention Policy

One of my clients wanted to know the default SCOM Data Warehouse data retention policy and wanted to modify the same according to their SCOM environment. A Data Warehouse is often one of the largest databases supported by an organization.  Large databases cost money and time to support.  They are difficult to maintain and costs more to backup. They will take much more time to restore in case of...

Read More