Related Articles
System Center – SQL Server 2008 R2 Performance Tuning
Posted on Author stefanroth
In this article I would like to share some SQL Server performance tuning tricks which will give an extra boost to your System Center infrastructure. I will focus on SQL Server 2008 R2 as this is the latest SQL Server edition. My attempt was to create a generic tuning guide for System Center but because […]
SCOM 2012 – Event ID 4001 GetSQL2012SPNState.vbs, Missing Database Instances
Posted on Author stefanroth
During a past SCOM engagement I was asked to implement SQL Server Management Pack 6.6.0 for monitoring SQL Server 2012. This MP is getting better with every release and works in most cases without any issue. I had two SQL Servers which were placed in the same domain and were configured identically. The only difference […]
SCOM 2012 – Effective Configuration Viewer The PowerShell Way
Posted on Author stefanroth
A customer requested to have a capability to get an overview of the effective configured settings for rules / monitors and its values for Windows Computer objects. For some administrators browsing through the SCOM console is just too time consuming and / or too complicated. There are not many ways of providing a simple solution […]