Tag Archives: #2012 R2

SCOM: Updated SQL Server Management Packs v6.7.7.0

7 Replies

New versions of the SQL Server management packs are out! They are available from the below links:

Note: Be aware that there have been some serious issues with previous versions of the SQL management packs this year. I cannot stress enough the need for testing before using these in a live environment.

SQL Server 2016: here
SQL Server 2014: here
SQL Server 2008 / 2012: here
SQL Dashboards: here

New in this version

SQL Server 2008 / 2012

  • Fixed issue: SQL Server 2012 Always On discoveries fail after stopping WSFC service
  • Fixed issue: “Set DB offline” task does not work when the database is in Availability Group
  • Fixed issue: user policy discovery script fails with “Invalid namespace “ROOT\Microsoft\SqlServer\ComputerManagement12″‘ error
  • Fixed issue: Always On console task does not work
  • Updated the visualization library

SQL Server 2014 / 2016

  • Fixed issue: “Set DB offline” task does not work when the database is in Availability Group
  • Fixed issue: Always On console task does not work
  • Updated the visualization library

Dashboards

  • Fixed issue: expanding “arrow” has low-contrast color when a health group is collapsed in Instance view (High-Contrast #2 color scheme)
  • Fixed issue: in Web console, Dashboards continuously send requests to the database
  • Fixed issue: not the first object gets selected in the object list after drill-down
  • Fixed issue: horizontal scroll position resets after refreshing the Instance view
  • Fixed issue: “No Data” message is displayed on some tiles after upgrading Dashboards management pack from version 6.7.2.0 to 6.7.4.0 or later version
  • Fixed issue: on Web console, Dashboards crash when drilling down from Datacenter view to Instance view
  • Restored the correct group order in SQL Server Summary dashboard views

Loading

SCOM: MP for .NET Application Performance Monitoring with Visual Studio Application Insights

Leave a reply

A new preview management pack if you which extends the APM functionality to include Visual Studio Application Insights get it here

Here is a nice set of installation instructions.

Note that this is a preview so I would suggest extensive testing before using in a live environment.

Loading

SCOM: Updated Windows Server 2012 DHCP MP v6.0.7301.0

2 Replies

An update has been released for the Windows Server 2012 DHCP MP version 6.0.7301.0 is available here.

What’s new

  • If the property scope id length of the failover server watcher class exceeded the max length, then Failover Server Watcher was not being discovered and hence could not monitor DHCP failover servers. The fix ensures that discovery is successful.
  • In a DHCP server with multiple scopes, if two or more scopes have same name when the alert raise for one scope it automatically raises the alert for another same scope name. The fix ensures that alerts are sent only for generated scope.

Loading

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

5 Replies

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,

Loading

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

Leave a reply

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

Loading

SCOM: Updated Windows Server Operating System MP v6.0.7316.0

Leave a reply

A new version of the Windows server OS MP was released version 6.0.7316.0 can be downloaded from here.

I would advise lab testing is possible due to the previous version of this MP mysteriously being removed from the catalog without any explanation.

The documentation only lists an updated to the “Troubleshooting and Known Issues” section. A comprehensive list is available in the MP guide.

Loading