We are happy to announce the public preview release of System Center Management Pack for Azure SQL Database – Managed Instance! This is a brand new MP to monitor the new Azure SQL Database – Managed Instance. We are looking forward to getting your feedback on the preview. Please email us at sqlmpsfeedback@microsoft.com.

Download available:

Microsoft System Center Management Pack (Community Technology Preview) for Microsoft Azure SQL Database – Managed Instance

The Management Pack (CTP) for Microsoft Azure SQL Database – Managed Instance enables you to monitor the availability and performance of your Managed Instances.

Note: This Management Pack is neither part of Microsoft System Center Management Pack for Microsoft Azure nor Microsoft System Center Management Pack for Microsoft Azure SQL Database. This management pack provides monitoring, which is quite similar to monitoring of on-premises SQL Server 2017 provided by the Microsoft System Center Management Pack for SQL Server 2017+.

Note: This CTP release covers only a subset of monitors and rules. It does not offer low-privilege monitoring configuration. We will work towards the full functionality as we release new CTPs.

Feature Summary

After configuration, the Microsoft Azure SQL Database – Managed Instance Management Pack (Community Technology Preview) offers the following functional capabilities:

• User-friendly wizard to discover Managed Instances
• Support for Multiple Managed Instances
• Monitoring of Managed Instance health and performance
  • Managed Instance availability and performance
    • Managed Instance Health Status
    • Managed Instance Securables Configuration
    • CPU Consumption
    • Average Wait Time
    • SQL Re-Compilation
    • User Connections
    • HTTP Storage Performance
    • Memory-Optimized Data Transactions Performance
    • and others
  • Database availability and performance
    • Database Status
    • Database Configuration
    • Database Performance
    • Memory-Optimized Data Filegroups Configuration
    • Memory-Optimized Data Filegroups Performance
    • Resource Pool Performance

Managed Instance will show up as first level folder under Monitoring on your SCOM console.

Let’s block ads! (Why?)

SQL Server Release Services