Monitor Azure Database
Description
Azuredb Metric plugin collects metrics related to relational database services like Azure SQL, Azure database for MySQL and Azure database for PostgreSQL using insights data from Azure Monitor.
Prerequisites
Plugin supports two modes of authentication and authorization
Managed Service Identity (MSI)
Registered APM controller with Managed identity enabled will auto-authenticate and authorize the plugin client without any credentials being passed as input parameter.
Service Principal Token
Token based Authentication is required if MSI is not available Steps to obtain Service Principal Token,
- Register an Application in Azure Active Directory and create a service principal
- Assign a role as Application Insights Component Contributor which has read access to Insight component.
- Create a secret by which application uses to prove its identity.
Collect ClientID, ClientSecret, TenantId, SubscriptionId from registered app
For more detailed information please refer Azure Docs .
Configuration Settings
Plugin can be set to monitor intended service by setting respective configuration. It needs to be configured to work along with either of the snappyflow database plugins - MySQL,PostgreSQL, SQLDB ,based on endpoint service type. Inbound traffic setting should be set to allow traffic from controller instance.
General Parameters
- Resource Group
- Region
- DB Server
Documents
Metrics are collected and relevant tags are added to the metric document
Dashboards and alerts templated are chosen based on monitored database service type
- For Azure MySQL relational service, Azure MySQL dashboard and Azure MySQL alert template needs to be applied
- For Azure SQL service, Azure SQL dashboard and Azure SQL alert template needs to be applied
- For Azure PostgreSQL service, Azure PostgreSQL dashboard and Azure PostgreSQL alert template needs to be applied
For help with plugins, please reach out to support@snappyflow.io.