What is Azure SQL Elastic Pool?
Azure SQL Elastic Pool is a resource pool of databases with a shared set of resources. It allows managing multiple databases with varying and unpredictable workloads under a single pool of resources, rather than provisioning resources for each database individually. Resources within the pool are dynamically allocated to databases based on demand, ensuring optimal utilization and cost-effectiveness.
It is suitable for scenarios where you have multiple databases with fluctuating usage patterns, allowing you to consolidate resources and reduce costs while maintaining performance and scalability.
Azure SQL Elastic Pools monitoring
This package automatically configures the ServicePilot Agent in order to monitor availability and performance of Microsoft Azure SQL Elastic Pool resources and services with the Microsoft API.
The ServicePilot database-azure-sql-pool package collects the following metrics:
- Memory usage
- CPU usage
- Disk I/O
- Network usage
How to install a azure-sql-elastic-pool resource?
- Use your ServicePilot OnPremise installation or a SaaS account.
- Add a new azure-sql-elastic-pool resource via the web interface (
/prmviewsor/prmresources) or via API (/prmpackagespage), the default ServicePilot agent or another agent will be provisioned automatically.
Details of the azure-sql-elastic-pool package are located in the
/prmpackagespage of the software.
Benefits
ServicePilot enables you to deliver IT services faster and more securely with automated discovery and advanced monitoring features.
By correlating the technology AZURE SQL ELASTIC POOL with APM and infrastructure monitoring, ServicePilot is able to provide a more comprehensive view of an organization's IT environment.
This allows IT teams to quickly identify and diagnose issues that may be impacting application performance, and take corrective action before end-users are affected.
Start with a free trial of our SaaS solution. Explore our plans or contact us to find what works best for you.
