LM Cloud

Azure SQL Databases

LogicMonitor currently has one DataSource for monitoring Azure SQL database performance metrics:

  1. Microsoft_Azure_SQLDatabase - collects performance data for Azure SQL databases

 

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.