Monthly Archives: August 2016

SCOM: Alerting when a server is up for more than X days

If you ever need to alert if a server has been online for more then a specific time period, you can achieve this with the following method. In this example we will be alerting if the server is up for more than 60 days.

Firstly create a unit monitor >  Windows Performance Counter < Single Threshold > Simple Threshold, targeting a relevant target, in this case we used Windows Computer.

41

Then specify the performance counter to target the System Up Time Counter which is part of the System Object,

2

The threshold value is in seconds and needs to be set according to your requirement, in our case 60 days is 5184000 seconds.

3

You can then leave the alert details as is or specify a custom message. You will now get an alert for any server that is online for more then 60 days,

SCOM: SQL Server MP (Community Technical Preview 1) v6.7.3.0

Another update for the SQL Community Technical Preview management packs this time we have updates for the SQL Server MPs and no changes to the dashboards. Get the MPs here.

SQL Server 2014 / 2016:

  • Disabled Memory-Optimized Data Garbage Collection Fill Factor monitor and rule by default
  • Disabled Memory-Optimized Data workflows for all SQL Server instances, except for Developer, Enterprise, and Evaluation editions
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

SQL Server 2008 / 2012

  • Added support for databases stored on SMB Shares
  • Fixed error logging in a script for Blocking Sessions monitor
  • Removed from the installer SQL 2005 MP files as no longer supported
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed Non-Readable Replica detection (Always On)
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

Management Pack Recap – July 2016 Wave

This is a summary of the wave of Management Packs that were released in July 2016. Information and download location in the links provided:

NiCE Oracle MP 4.00here
Microsoft Azure (Technical Preview) MP v1.3.22.0 – here
Windows Server Operating System MP v6.0.7316.0here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them