Menu Close

Author: Kevin Holman

How to transition to the SQL Version Agnostic MP

This is based on the SQL MP Version 7.0.20.0 and later. https://www.microsoft.com/en-us/download/details.aspx?id=56203 This MP supports discovery and monitoring of SQL 2012, 2014, 2016, 2017, 2019, and later versions of SQL Server.  It is completely different than all previously released SQL Management Packs, the older ones I will refer to as…

Self Tuning Thresholds – love and hate

Mostly hate.  Self tuning thresholds were a new concept for OpsMgr 2007.  They “attempt” to “learn” what is normal for a performance counter, and alert when the value is outside of the learned baseline.  This is great when we have performance counters that will vary widely from company to company,…