Databases
The Database Workbook allows you to review the types and redundancy of several database versions. This Workbook focuses solely on the following databases:
- Azure SQL Database
- Azure Synapse Analytics
- Cosmos DB
- MySQL
- Redis
- PostgreSQL
In the Summary, you can review an overview of non-recommended options on the Azure SQL Database.
| Column | Description | Recommendation |
|---|---|---|
| Resource Total | Represents the total number of resources. The bar below the number indicates the percentage of resources with recommended settings. | - |
| Failed Status | Indicates the count of databases that have the status of stopped. | - |
| Non-production SKU | Represents the number of Azure SQL Databases that are not using production grade sku. | Upgrade from Basic, Standard or System sku. |
| No Availability Zone | Indicates the count of databases that do not span across zones. | When configuring the service and compute tier choose the option to enable the database to be zone redundant. |
| No GRS Backup | Indicates the count of databases that do not have automatic geo redundant backups created. | Configure backups for geo redundancy. |
Inspect the detailed status of each Azure SQL Database.
| Column | Description | Data source |
|---|---|---|
| Subscription | Represents the Subscription. | ARG(resources.subscriptionId) |
| SkuName | Indicates the type (e.g., Developer, Production). The following are marked with an alert icon as they are not recommended: - storage: Indicates usage of Storage V1. |
ARG(resources.sku) |
| Kind | Indicates the type (e.g., version, service tier, compute tier... ). | ARG(resources.kind) |
| State | Represents the provisioning state. | ARG(resources.properties.status) |
| Location | Indicates the deployment location. | ARG(resources.location) |
| Resource Group | Represents the deployed Resource Group. | ARG(resources.resourceGroup) |
| AvailabiltyZone | Indicates whether zones are used. There are three types: Not Applicable, Configured, and Not Configured. The following are marked with an alert icon as they are not configured: - Not Configured: Indicates that zones are not being selected. |
ARG(resources.properties.zoneRedundant) |
| Capacity | Represents the DTU or vCore capacity | ARG(resources.sku.capacity) |
| Storage Type | - | ARG(resources.properties.storageAccountType) |
| Replication Role | Represents the database role as master if the secondary type is not configured. | ARG(resources.properties.secondaryType) |
| Environment | Represents the value of the Environment tag attached to the resource. |
ARG(resources.tags) |
In the Summary, you can review an overview of non-recommended options on the PostgreSQL databases.
| Column | Description | Recommendation |
|---|---|---|
| Resource Total | Represents the total number of resources. The bar below the number indicates the percentage of resources with recommended settings. | - |
| Failed Status | Indicates the count of databases that have the status of stopped. | - |
| Non-production SKU | Represents the number of PostgreSQL databases that are not using production grade sku. | Burstable is considered a development non-production comptuer tier. |
| No Availability Zone | Indicates the count of databases that do not span across zones. | Enable high availability first on the database, and then select a zone option. Select a computer tier of General Purpose or Memory Optimized for availability zone options. |
| No High Availability | Indicates the count of databases that do not have high availability options enabed. | Enable high availability on the database. Select a computer tier of General Purpose or Memory Optimized for availability zone options. |
| No Geo Backup | Indicates the count of databases that do not have automatic geo redundant backups created. | Configure backups for geo redundancy. |
Inspect the detailed status of each PostgreSQL Database.
| Column | Description | Data source |
|---|---|---|
| Subscription | Represents the Subscription. | ARG(resources.subscriptionId) |
| Sku Name | Indicates the type (e.g., Developer, Production). The following are marked with an alert icon as they are not recommended: - storage: Indicates usage of Storage V1. |
ARG(resources.sku) |
| Status | Represents the provisioning state. | ARG(resources.properties.state) |
| Location | Indicates the deployment location. | ARG(resources.location) |
| Resource Group | Represents the deployed Resource Group. | ARG(resources.resourceGroup) |
| AvailabiltyZone | Indicates whether zones are used. There are three types: Not Applicable, Configured, and Not Configured. The following are marked with an alert icon as they are not configured: - Not Configured: Indicates that zones are not being selected. |
ARG(resources.properties.highAvailability.mode) |
| High Availabilty | Indicates whether zones are used. There are four types: Not Applicable, Configured, Same Zone, and Not Configured. The following are marked with an alert icon as they are not configured: - Not Configured and Same Zone: Indicates that zones are not being selected, or redundant across zones. |
ARG(resources.properties.highAvailability.mode) |
| Replication Role | Represents the database role as primary or as a replica. | ARG(resources.properties.replicationRole) |
| GeoBackup | Indicates whether geo backups are configured. There are three types: enabled, disabled, and not applicable. The following are marked with an alert icon as they are not configured: - disabled: Indicates that geo backups have not been configured. |
ARG(resources.properties.backup.geoRedundantBackup) |
| Environment | Represents the value of the Environment tag attached to the resource. |
ARG(resources.tags) |