First published on MSDN on Feb 08, 2018
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 D...
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.