SQL Elastic Pool Monitoring
  • Updated on 05 Sep 2019
  • 2 minutes to read
  • Contributors
  • Print
  • Share
  • Dark
    Light

SQL Elastic Pool Monitoring

  • Print
  • Share
  • Dark
    Light

SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price. Elastic pools in Azure SQL Database enable SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.

Associating Azure SQL Elastic Pool to Composite Application

Serverless360 facilitates Data Monitoring on Azure SQL Elastic Pool.
Below is an illustration on associating an Azure SQL Elastic Pool to a Composite Application.

associate-elastic-pool

Once an Azure SQL Elastic Pool is associated with a Composite Application in Serverless360, it is possible to monitor the Azure SQL Elastic Pool in various perspectives using the monitors in Serverless360.

Monitor Azure SQL Elastic Pool based on Metrics

If the intention is to understand the utilization or consumption of the Azure SQL Elastic Pool then the choice should be a Serverless360 Data Monitor. Data Monitoring can be configured for an Azure SQL Pool on an extensive set of metrics.
The table below lists down the metrics to monitor the Azure SQL Elastic Pool in various perspectives using Serverless360 Data Monitor.

Monitoring Purpose Metrics to Choose
Check the used percentage of CPU, Data IO, Log IO, DTU CPU Percentage (%),Data IO Percentage (%), Log IO Percentage (%), DTU Percentage (%)
Check the Workers percentage Workers percentage (%)
Check the Sessions percentage Sessions percentage (%)
Check the Data space allocated Data space allocated (Bytes)
Check the Maximum Data size Data max size (Bytes)
Check the used percentage of Data space Data space used percent (%)
Check the In-Memory OLTP storage percent In-Memory OLTP storage percent (%)
Check the DTU Limit eDTU Limit (Count)
Check the DTU Used eDTU used (Count)
Check the Data space allocated Data space allocated (Bytes)
Check the Data space allowed Data space allocated percent (%)

Data Monitor can be configured for various combination of metrics to meet the monitoring requirements. Data monitor on Azure SQL Elastic Pool can be set as in the illustration below

associate-elastic-pool-dm

Note: All the Azure SQL Elastic Pools associated within a Composite Application can be monitored on their metrics.

We'd love to hear your thoughts
Please visit our feedback system to suggest new Features or Enhancements. You can also take a look at our Roadmap
Was this article helpful?