Version 6.1.5.10 of Foglight for Azure SQL contains the following new features and updates:
- Add support for monitoring Azure SQL DB Elastic Pools (FOG-4248).
- An overview dashboard shows the resource consumption across all Server Elastic Pools and their associated databases.
- New related 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.
- Permissions needed to monitor elastic pool: connect to the virtual master database.
- New ability to add Azure databases to monitor via CLI.
- Support User Level Access for Azure SQL databases and Elastic Pools.
The following is a list of issues addressed and enhancements implemented in this release.FOG-4569 Support User Level Access for Azure SQL connections, database and Elastic Pool