Azure SQL Databases
LogicMonitor currently has the following DataSources for monitoring Azure SQL database performance metrics:
- Microsoft_Azure_SQLDatabase – collects performance data for Azure SQL databases
- Azure_SQLServer_JDBC – polls Azure SQL Database from a Collector installed within an Azure virtual network
Microsoft_Azure_SQLDatabase
Source: Azure Insights API
Datapoints:
- BlockedByFireWall
- ConnectionFailed
- ConnectionSuccessful
- CPUPercent
- DTUConsumptionPercent
- DTULimit
- DTUUsed
- LogWritePercent
- PhysicalDataReadPercent
- SessionsPercent
- Storage
- StoragePercent
- WorkersPercent
- XTPStoragePercent
Default Polling Interval: 1minute
Additional Configuration Necessary?: No. This DataSource will automatically apply to all SQL Databases discovered for your Azure account & start collecting data.
Azure_SQLServer_JDBC
This DataSource is compatible with both a SQL Server on an Azure VM or an Azure SQL Database.
Requirements:
system.categoryon the device must be set to"azure-sql".- Specify the Collector in the Azure SQL instance Manage settings.