Overview

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

Azure SQL Database

Summary

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.

Detail of resources

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)

PostgreSQL

Summary

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.

Detail of resources

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)