What Are PaaS Databases in Combine?
Platform as a Service (PaaS) Databases are cloud-based database solutions that allow users to manage and deploy databases without dealing with the complexities of infrastructure. These databases provide scalability, high availability, and a range of automation features. By using PaaS databases, organizations can focus on application development while the platform manages the underlying database infrastructure.
The Azure PaaS Databases report in Combine provides a centralized view of your PaaS database instances. It offers actionable insights into your Azure SQL, MySQL, and PostgreSQL databases. This section is instrumental in optimizing resource usage, ensuring compliance, and identifying cost-saving opportunities.
This Azure PaaS Databases section can be found in the following path in Combine:
Cloud Reports > Azure Management > PaaS Databases
Overview of the Azure PaaS Databases
The Azure PaaS Databases section provides a comprehensive report that includes:
- SQL Engine Version Distribution:
Gain a quick overview of the distribution of database engine versions across your environment. Each segment represents the percentage of databases running a specific version, enabling you to:
- Identify outdated versions that may require upgrades.
- Plan for standardization across the environment.
- Ensure compliance with organizational or industry standards.
- Exportable Data Grids:
The exportable data grid provides granular details about your PaaS databases. You can filter by database type (Azure SQL, MySQL, PostgreSQL) and export the data for external analysis. Key columns include:
Subscription ID: Unique identifier for the subscription under which the resource is hosted.
Subscription Name: Friendly name of the Azure subscription.
Name: Name of the PaaS database instance.
Resource Group: The resource group containing the database.
Resource Type: Type of resource (e.g., Azure SQL, MySQL, PostgreSQL).
Resource Tags: Custom metadata tags applied to the resource for categorization.
Location: Azure region where the database is hosted.
Resource SKU: The specific SKU or pricing tier of the database instance.
Storage Capacity (GB): Total allocated storage for the database.
vCPU: Number of virtual CPUs assigned to the database.
RAM (GB): Amount of memory allocated to the database instance.
Resource Version: Major version of the database engine.
Resource State: Current state of the resource.
- Configuration Settings:
By clicking the gear icon, users can configure the following settings in the Azure PaaS Databases Settings window:
Poll Interval: Adjust how frequently the platform collects resource utilization data (options: 60 or 120 minutes).
Data Retention: Specify how long utilization data is retained (options: 10, 20, 30, 40, 50, or 60 days).
Resource Status Toggle: Enable or disable resource metrics collection.
- Note: Collecting metrics may incur additional costs. For detailed cost information, visit Azure Monitor Pricing.
By leveraging the insights provided in this report, organizations can effectively manage their Azure PaaS database infrastructure, optimize resource usage, and ensure compliance.