ParkMyCloud supports the discovery and “soft parking” of Azure SQL databases, with vCore and DTU pricing models. Azure does not allow stopping or suspending Azure SQL databases outright, so ParkMyCloud has added a new mechanism that enables you to choose a minimum available configuration for the respective databases to significantly reduce spend.
Azure SQL Databases are listed in the main resources page, and are visible in the Databases quick filter. They are displayed as parkable workloads, and are subject to the same parking scheduling technology that we provide for other resource types.
The database details screen now includes a “Spend Optimizer” tab. There are two sections providing insight into the current soft parking configuration, and other possible configurations.
Database Spend Optimizer
This shows the running state and the parked state configuration of your Azure SQL database. The “running state” is the current configuration of your database resource and the “parked state” is the selected economy setting for when this resource is parked.” Note that these items are still running but minimized to maximize savings.
Current Used Storage – this is dependent on ParkMyCloud having metric access
Max Storage (current tier max supported storage limit)
Family Name, as is displayed in the Azure console
Cost (per month)
Maximum Estimated Savings per month. This is applicable to the parked state only
Desired Economy Setting
This table includes the lowest available compute and storage configuration options for your Azure SQL database within the same product family. Note that when used storage amount is not available, all configuration options will retain the current allocated storage amount. Choose the desired configuration to apply to your Azure SQL database when parking this resource.
If metrics are not available for the given resource, we will not recommend configurations with less available storage
For DTU pricing tier databases we provide a recommendation to reduce the storage amount only when storage is not free. If storage amount is within the included free storage range, we do not make any storage reduction recommendations
vCores Spend Optimizer Tab
DTUs Spend Optimizer Tab
Maintain the defined maximum storage amount
Minimize the compute (vCores or DTUs)