Blog Post

SQL Server Blog
2 MIN READ

Released: SQL Server Management Pack (7.0.24.0)

EbruErsan's avatar
EbruErsan
Icon for Microsoft rankMicrosoft
Aug 21, 2020

An updated version of SQL Server Management Pack is ready. It has many new features which are mostly based on your feedback.

 

Please download at:

Microsoft System Center Management Pack for SQL Server

 

What’s New

  • Added a new “Securables Configuration Status” monitor targeted to SQL Server databases

  • Updated the “Product Version Compliance” monitor with the most recent versions of public updates for SQL Server

  • Updated the “Securables Configuration Status” monitor targeted to the DB Engine when a SQL Server instance participates in Availability Groups

  • Removed the “Securables Configuration Status” monitor targeted to the Availability Replica as non-useful

  • Updated the “SQL Server Database Engines” discovery; the “Netbios Computer Name” property is now uppercased.

  • Added reports from version-specific management packs for SQL Server
  • Updated monitor “Job Duration” to add current job run's duration to its alert description
  • Updated Web Console version of SQL MP Dashboards to support SCOM 2019 UR1
  • Updated alert description of monitor “Securables Configuration Status”
  • Added “CheckStartupType” property to SSIS Health Status monitor
  • Revised columns of SQL Agent and SQL Agent Jobs state views
  • Updated display strings

Issues Fixed

  • Fixed error “Unsupported path format” in workflows targeting Filegroups
  • Fixed discovery error on non-readable availability replicas
  • Fixed wrong Run As profile in SSIS Seed Discovery
  • Fixed issue that caused rule “Disable Discovery of Selected DB Engines” to fail
  • Fixed discovery issue for databases in recovering state
  • Fixed issue in monitor “Securables Configuration Status” when it went critical on Shared-Memory-only SQL Servers

  • Fixed the Alerting Rules data source to avoid an alert storm after exiting maintenance mode

  • Fixed the SQL Log Reader data source to support changing of the SQL Authentication method

  • Fixed the Performance Reader data source to support changing of the SQL Authentication method

  • Fixed issue in data source of SPN Status monitor that may lead to memory leak

We are looking forward to hearing your feedback.

 

Updated Sep 07, 2020
Version 2.0
sqlreleases
  • DVKalashnikov's avatar
    DVKalashnikov
    Brass Contributor
    Apr 27, 2021

    Hello @RMacN1295,

    Now we're preparing the next release of the SQL Server MP and looked at this feature request. Currently, we found that the monitor "Long Running Jobs" calculates the duration time for jobs that currently running as well as for jobs that have already been completed. Its behavior not quite clear and could lead to false positives. Could you please tell us it's that fix are you waiting for, or are we missing something? Btw, the better way to maintain the conversation is our alias SQLMPsfeedback@microsoft.com

    Thank you!

  • DVKalashnikov's avatar
    DVKalashnikov
    Brass Contributor
    Oct 19, 2020

    Hello RMacN1295 , thanks for reaching us out!

    We’ll put this item in our backlog for the next release, but no more precise ETA yet though.

    We look forward to hearing your feedback in the future.