Docs » Integrations Guide » Integrations Reference » Microsoft Azure SQL Elastic Pools

image0 Microsoft Azure SQL Elastic Pools

DESCRIPTION

Use SignalFx to monitor Azure SQL Elastic Pools via Microsoft Azure.

FEATURES

  • Azure SQL Server Elastic Pool: Shows metrics of an Elastic Pool.
  • Azure SQL Server Elastic Pools: Shows metrics of all Elastic Pools being monitored.

INSTALLATION

To access this integration, connect to Microsoft Azure.

USAGE

Interpreting Built-in dashboards

Azure SQL Server Elastic Pool

  • eDTU Used per Database in Elastic Pool vs eDTU Limit - Shows a comparison of the eDTU limit to the eDTU used aggregated by database.
  • DTU Percentage Trend - Trend of the DTU used percentage aggregated by database.
  • Server CPU Percentage - Shows the load on the CPU aggregated by database.
  • Data I/O Percentage - Shows the used percentage of Data I/O aggregated by database.
  • Log I/O Percentage - Used percentage of Log I/O aggregated by database.
  • Elastic Pool Storage Used Percentage - Trend of total elastic pool storage used.
  • Elastic Pool Storage Used per Database - Trend of total elastic pool storage used aggregated by database.

Azure SQL Server Elastic Pools

  • Top Elastic Pools by DTU Consumption percent - Lists the elastic pools with top DTU consumption percent.
  • Top Elastic Pools by eDTU Used - Shows the eDTU used stacked by elastic pool.
  • Top Elastic Pools by Total Storage - Shows a stacked chart of the total storage aggregated by elastic pool.
  • Top Elastic Pools by Workers Percentage - Shows the trend of workers percent for top elastic pools
  • Top Elastic Pools by Storage percent - List of the elastic pools with top used storage.
  • Top Elastic Pools by Sessions Percentage - Shows the trend of sessions percent for top elastic pools

METRICS

For more information about the metrics emitted by Azure SQL Elastic Pools, visit here.