The Foglight cartridge for Azure SQL DB (v. 6.1.5) is now generally available (11/28/22).
In this release, specific monitoring support for Azure SQL DB Elastic Pools (FOG-4248) was added.
What is Azure SQL DB Elastic Pools?
When resource consumption varies widely and patterns of usage are unpredictable, consider an Azure SQL DB Elastic Pools deployment. Databases with workloads can dynamically pull resources while databases with no activity use none. In this way, the databases are ‘elastic’.
The databases in an elastic pool are on a single server and share resources (an amount that you decide, either on the DTU-based or vCore-based) at a set price and billed at the elastic pool level.
- As a general rule, if the sum of the DTUs of performance levels for single databases is more than 1.5x the eDTUs needed for the pool, then an elastic pool is more cost-effective.
Foglight
Global View Dashboard:
The Global View has an Elastic Pool tab accessed via the Azure SQL tile.
Overview dashboard:
This displays the resource consumption across the server elastic pools and the databases that are members of the pool.
Alarms:
- Usability alarm: Notify when Elastic pool (Master DB) is unresponsive and not monitored by Foglight.
- CPU consumption is over a threshold (vCore): Notify when Elastic Pool (vCore) CPU utilization is above the CPU limit threshold.
- DTU consumption is over a threshold (DTU): Notify when Elastic Pool (DTU) utilization is above the threshold.
- Data IO consumption is over a threshold (vCore): Notify when Elastic Pool Data IO utilization is above the Data IO limit threshold.
- Log IO consumption is over a threshold (vCore): Notify when Elastic Pool vCore storage utilization is above the Log IO limit threshold.
- Storage utilization is over a threshold: Notify when Elastic Pool Storage utilization percent is above the threshold.
- Max sessions are over a threshold: Notify when the Maximum concurrent sessions percentage reaches the Elastic Pool limit.
Resources:
github.com
learn.microsoft.com
youtube.com
