Released: SCOM Management Packs for SQL Server, RS, AS and Azure SQL MI (7.6)

Updates to SQL Server, SQL Server Dashboards, Reporting Services, Analysis Services, and Azure SQL Managed Instance Management Packs are available (7.6). You can download the MPs from the links below. The majority of the changes are based on your direct feedback. Thank you!

There are new features as well as some bug fixes in these MPs. You can find the full list by following the links below. Some of the bigger additions are:

For Azure SQL Managed Instance:

Enhanced the Automatic template options for monitoring SQL Managed Instances by introducing support for Managed Identity. This includes both System-assigned and User-assigned Managed Identity options

For SQL MP:

Added support for Custom query-based database monitors with two options depending on the type of query: database context or cookdown
Added new “Property Bag” step in the custom monitor setup to extend the alert context with properties from the query result

For AS MP:

Added “VertiPaq memory paging indication” monitor to observe the level of VertiPaq memory paging
Improved accessibility for the Summary Dashboard view and Monitoring Wizard template
Updated the “Product Version Compliance” monitor with the most recent version of public updates for SQL Server

The operations guides for all SQL Server family of management packs are live on learn.microsoft.com. The link to the operation guide for each MP can be found on the MP download page. Here are the links that show what’s new in these MPs:

Features and Enhancements in Management Pack for Azure SQL Managed Instance

Features and Enhancements in Management Pack for SQL Server

Features and Enhancements in Management Pack for SQL Server Dashboards

Features and Enhancements in Management Pack for SQL Server Analysis Services

Features and Enhancements in Management Pack for SQL Server Reporting Services

Microsoft Tech Community – Latest Blogs –Read More