Blog Post

SQL Server Blog
2 MIN READ

Released: SQL Server Management Pack (7.0.20.0)

EbruErsan's avatar
EbruErsan
Icon for Microsoft rankMicrosoft
Dec 27, 2019

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

 

Please download at:

Microsoft System Center Management Pack for SQL Server

 

What’s New

  • Updated MP to support SQL Server 2019 RTM
  • Added filter by edition to “Local DB Engine Discovery”
  • Redesigned DB Space monitoring to improve performance: Enabled by default monitors and performance rules targeting Database which watch for disk space consumption by ROWS Filegroups and Logfiles
  • Redesigned DB Space monitoring: Added two monitors and two performance rules targeting Database to watch for disk space consumption by In-Memory and FILESTREAM data
  • Redesigned DB Space monitoring: Read-only filegroups now count as well
  • Redesigned DB Space monitoring: Disabled by default all workflows targeting Filegroups, Files, Logfiles
  • Redesigned XTP performance counters to make them completely version-agnostic
  • Added attribute “TCP Port” to “SQL DB Engine Class” and updated “DB Engine Discovery” to populate the new property
  • Added summary dashboard for SCOM 2019 Web Console (HTML5)
  • Added support for cluster nodes with disjoined namespaces
  • Added sampling to algorithm of monitor “WMI Health State” in order to eliminate false alerting on cluster SQL Server instances
  • Updated alert descriptions of monitors “Availability Database,” “Availability Replica,” and “Availability Group” (generating alerts still disabled by default)
  • Updated monitor “Product Version Compliance” with versions of most recent public updates to SQL Server
  • Disabled by default monitor “Buffer Cache Hit Ratio” and changed its threshold from 0% to 90%
  • Disabled by default monitor “Page Life Expectancy”
  • Removed monitors “Availability Database Join State” and “Availability Replica Join State” as not useful
  • Updated display strings
  • Revised columns on DB Engine state views

Issues Fixed

  • Fixed: monitor “Service Principal Name Configuration Status” raises false alerts because of case-sensitive comparison
  • Fixed: “Local DB Engine Discovery” crashes when Windows has Turkish locale
  • Fixed issue that caused performance degradation in workflows “General Always On Discovery,” “Database Replica Discovery,” and “Always On System Policy Monitoring”
  • Fixed: “General Always On Discovery” throws errors on environments with several Distributed Availability Groups
  • Fixed monitoring issue in case of Database is replicated by Always On Availability Group
  • Fixed empty property bag when Availability Group has cluster type NONE
  • Fixed wrong target in alerting rule “DB Backup Failed to Complete”
  • Fixed rule “MSSQL Integration Services on Windows: The package restarted from checkpoint file” and its alert
  • Fixed rule “OS Error occurred while performing I/O on pages“ and its alert
  • Fixed: "DB Disk Write Latency" and "DB Disk Read Latency" monitors and performance rules get wrong performance metric
  • Fixed alert description of monitor “WMI Health State”

We are looking forward to your feedback.

Updated Dec 30, 2019
Version 2.0
  • mkmaster78's avatar
    mkmaster78
    Copper Contributor

    Great Work!

    Thanks for adding in an HTML5 dashboard, much appreciated. I did notice a few issues with the dashboard, but they totally could be on my end, but if you could let me know, I'd appreciate it.

    1) Even though it looks like a clickable link, the status panels cannot be clicked.  If you do click nothing happens, if you double-click, it pops up with "error!"

    2) The data doesn't seem to quite line up with the dashboard in the regular console, e.g. if the console says (under SQL Server Instances) 2 of 10 critical with 20 alerts critical, the web dashboard says 2 of 10 critical with 1 alerts critical

     

    They're minor issues all told, but figured I'd see if you all had any ideas.

  • DVKalashnikov's avatar
    DVKalashnikov
    Brass Contributor

    Hi mkmaster78,

    Thank you for giving us your feedback on the SQL MP, we really appreciate it!

    Actually, the web-dashboards in SQL MP is in a beta status now. Currently, we're working on performance improvements and adding a load-indicator for dashboard tiles - that's why you can see nothing when clicking on a dashboard panel (tiles) for the first time, for example. As for unsynchronized data between classic SCOM-dashboard and web-dashboard, we're working on that.

    We're planning to fix these issues in the next version of the MP, but we don't have an ETA now.

    Stay tuned! :smile:

  • Hossein_Amiri's avatar
    Hossein_Amiri
    Copper Contributor

    Hi!

    Good time!

    I have a problem for work with SSMS!

    And my feedback hub part of windows has error and don't open!

    Please guide me for solution of these problems!

    Thank you!

    Hossein Amiri Baghbadorani