Undiscovering / Stop Monitoring SQL 2008/2012/2014/2016 Express Editions

This post is an update of https://blogs.technet.microsoft.com/emreguclu/2014/09/12/undiscovering-stop-monitoring-sql-200520082012-express-editions/ which adds SQL 2014 and SQL 2016 and removes SQL 2005 support to existing mp as per requests of customers. If you have the older version please just download and import this one. For all details about the configuration of the Management Pack, please visit Emre’s Blog. MP Download:…

0

Healthservice Service SID Type

Hi, While visiting customers, I’m often asked how to configure RunAs accounts for the SQL Management Pack. I love the new way using the Healthservice Service SID as Kevin Holman documented in his blog post over here: https://blogs.technet.microsoft.com/kevinholman/2016/08/25/sql-mp-run-as-accounts-no-longer-required-2/ I don’t want to go over the configuration of his Management Pack again. I just want to show…

0

SCOM Environment Classification

I often hear from customers that they are connecting all there Environments (Test, Acceptance, Production) to one SCOM environment. As expected, SCOM will generate alerts for all environments without making a difference between the environment. Customers are asking if we can split up the Environment monitoring in the SCOM console. A sollution could be making…

0

MSSQL: Monitoring failed – The pipe is being closed (System Center Management Pack for SQL Server 6.7.7.0)

Begin October 2016, the Management Pack for SQL server 6.7.7.0 got released. https://blogs.msdn.microsoft.com/sqlreleaseservices/released-system-center-management-pack-for-sql-server-and-dashboards-6-7-7-0/ Customers were seeing a lot of alerts regarding a known WMI bug: https://support.microsoft.com/en-gb/kb/956013 And AlwaysOn discovery issues, as described in the announcement post, most of them will be resolved in a next version of the Mangement Pack, as the TP version 6.7.10.0…

2

OMS – Service Map Solution – Unsigned Driver Windows Server 2016

Hi, A new Service Map solution got released for OMS lately (until now 25/11/2016 only available in US region) : https://docs.microsoft.com/en-us/azure/operations-management/-suite/operations-management-suite-service-map The solution requires an additional service to be installed as documented over here: https://docs.microsoft.com/en-us/azure/operations-management-suite/operations-management-suite-service-map-configure This image gives you more insight on how the “Microsoft Dependency Agent” works together with the “MMA/OMS Agent”   When…

1