SQL Cost Estimation

In this article

    The /sqlCostEstimation resource collection allows you to calculate the estimated monthly cost of using Microsoft Azure resources to protect Azure SQL databases. The estimated cost is available if you specified the backup schedule in backup policy settings.

    Collection URL

    The resource collection is located at the following URL:

    https://<hostname>/api/v3/sqlCostEstimation

    SQL Cost EstimationCollection Representation

    Request Body:

    {

     "priority": 1,

     "tenantId": "3e924ba9-93bc-40d5-8a47-33f07b239a52",

     "regions": [

         {

            "regionId":"northeurope"

         },

         {

            "regionId":"ukwest"

         },

         {

            "regionId":"westeurope"

         }

     ],

     "selectedItems": {

        "databases": [

         {

               "id":"ej43ifg58cgjs8e9cod74ye6cbwm5nttf6ijzk64rshqoip1abqy"

            },

            {

               "id":"g344t5o8hgxgyp9r5bxqsn1aom88kjsc3hjnk3o8umzdptc3w3ey"

            }

       ],

         

        "sqlServers": [

         {

               "id":"rg65igjs8e6cbwm5nfg58cttf6ije9cod74yzk64oip1abqyrshq"

            },

            {

               "id":"o8hg9r5bxqg344t5sn1aom88kjscnk3o8umzd3hjptc3w3eyxgyp"

            }

       ]

     },

     "excludedItems": {

       "databases": []

     },

     "stagingServerId": "string",

     "managedStagingServerId": "string",  

     "name": "backup policy-01",

     "description": "created by Default Admin",

     "retrySettings": {

       "retryCount": 6

     },

     "policyNotificationSettings": {

       "recipient": "adminc@tech.local",

       "notifyOnSuccess": true,

       "notifyOnWarning": true,

       "notifyOnFailure": true

     },

     "isEnabled": true,

     "backupType": "AllSubscriptions",

     

     },

     "dailySchedule": {

       "dailyType": "Everyday",

       "selectedDays": [

         "Sunday"

       ],

       "runsPerHour": 1,

       "snapshotSchedule": {

         "hours": [

           20:00:00

         ],

         "snapshotsToKeep": 7

       },

       "backupSchedule": {

         "hours": [

           20:00:00

         ],

         "retention": {

           "timeRetentionDuration": 2,

           "retentionDurationType": "Days"

         },

         "targetRepositoryId": "14"

       }

     },

     "weeklySchedule": {

       "startTime": 0,

     

       },

       "backupSchedule": {

         "selectedDays": [

           "Sunday"

         ],

         "retention": {

           "timeRetentionDuration": 0,

           "retentionDurationType": "Days"

         },

         "targetRepositoryId": "14"

       }

     },

     "monthlySchedule": {

       "startTime": 20:00:00,

       "type": "First",

       "dayOfWeek": "Sunday",

       "dayOfMonth": 1,

       "monthlyLastDay": true,

       

       },

       "backupSchedule": {

         "selectedMonths": [

           "January"

         ],

         "retention": {

           "timeRetentionDuration": 0,

           "retentionDurationType": "Days"

         },

         "targetRepositoryId": "14"

       }

     },

     "yearlySchedule": {

       "startTime": 0,

       "month": "January",

       "type": "First",

       "dayOfWeek": "Sunday",

       "dayOfMonth": 0,

       "yearlyLastDay": true,

       "retentionYearsCount": 0,

       "targetRepositoryId": "string"

     }

    }

     

    Response:

    200

     

    Response Body:

    {

     "metadata": {

       "totals": {

         "totalCosts": {

           "pricePerMonth": {

             "value": 133.15584213161907,

             "type": "Valid"

           },

           "warnings": []

         },

         "totalBackupCosts": {

           "pricePerMonth": {

             "value": 2.3619445218835025,

             "type": "Valid"

           },

           "warnings": []

         },

         "totalTrafficCosts": {

           "pricePerMonth": {

             "value": 115.40550232315063,

             "type": "Valid"

           },

           "warnings": []

         },

         "totalTransactionCosts": {

           "pricePerMonth": {

             "value": 0.6883952865849224,

             "type": "Valid"

           },

           "warnings": []

         }

       },

       "assumptions": {

         "diskOccupiedSizeRatio": 0.7,

         "dailyChurnRatio": 0.03,

         "dataCompressionRatio": 2

       },

       "warningGroups": [

         {

           "type": "StorageCouldBeCheaper",

           "text": "There are more cost-effective storage account alternatives than Standard_RAGRS, for example Standard_LRS.",

           "warnings": [

             {

               "id": "StorageCouldBeCheaper_7201feeca16d2c15e8a0b0cce8f43a2a",

               "protectedItemHashIds": [],

               "schedules": [

                 "Daily"

               ],

               "text": "There are more cost-effective storage account alternatives than Standard_RAGRS, for example Standard_LRS."

             }

           ]

         }

       ],

       "currencyIsoCode": "USD"

     },

     "offset": 0,

     "limit": 30,

     "totalCount": 2,

     "results": [

       {

         "protectedItemHashId": "1bds4myhyh4o66wzxk6ixcgp1xssgmwyhremj1su6ixj6p4snrny",

         "name": "rep-vm1",

         "backupCost": {

           "pricePerMonth": {

             "value": 1.1809722609417512,

             "type": "Valid"

           },

           "meters": [

             {

               "resource": {

                 "name": "rep-vm2",

                 "hashId": "rep-vm2_disk1_94bce520eee044358e842ad7d36c025d",

                 "resourceId": "/subscriptions/3a9a8330-7bbc-4b03-9c68-15d674fbc809/resourcegroups/-resourcegroup/providers/microsoft.compute/disks/rep-vm2_disk1_94bce520eee044358e842ad7d36c025d",

                 "size": 30

               },

               "meterId": "0623400b-f198-453e-b090-f09555b18e6a",

               "description": "Data Stored",

               "unitPrice": 0.049,

               "unit": "OneGbPerMonth",

               "quantityUsed": 17.11554001364857

                  },

           ],

           "warnings": []

         },

         "trafficCost": {

           "pricePerMonth": {

             "value": 57.702751161575314,

             "type": "Valid"

           },

           "meters": [

             {

               "resource": {

                 "name": "-server_disk1_94bce520eee044358e842ad7d36c025d",

                 "hashId": "duprymsckjawm1zxi1oatpmrinqqom3wamxm7gr7kto9h7xjn54y",

                 "resourceId": "/subscriptions/3a9a8330-7bbc-4b03-9c68-15d674fbc809/resourcegroups/-resourcegroup/providers/microsoft.compute/disks/-server_disk1_94bce520eee044358e842ad7d36c025d",

                 "size": 30

               },

               "meterId": "9995d93a-7d35-4d3f-9c69-7a7fea447ef4",

               "description": "Zone1/DataTransferOut",

               "unitPrice": 0.087,

               "unit": "OneGb",

               "quantityUsed": 663.2500133514404

             }

           ],

           "warnings": []

         },

         "transactionCost": {

           "pricePerMonth": {

             "value": 0.3441976432924612,

             "type": "Valid"

           },

           "meters": [

             {

               "resource": {

                 "name": "-server_disk1_94bce520eee044358e842ad7d36c025d",

                 "hashId": "duprymsckjawm1zxi1oatpmrinqqom3wamxm7gr7kto9h7xjn54y",

                 "resourceId": "/subscriptions/3a9a8330-7bbc-4b03-9c68-15d674fbc809/resourcegroups/-resourcegroup/providers/microsoft.compute/disks/-server_disk1_94bce520eee044358e842ad7d36c025d",

                 "size": 30

               },

               "meterId": "3fa85f64-5717-4562-b3fc-2c963f66afa6",

               "description": "Write Operations",

               "unitPrice": 0.108,

               "unit": "OneGb",

               "quantityUsed": 3.125057311304348

             }

           ],

           "warnings": []

         },

         "totalPerMonth": {

           "pricePerMonth": {

             "value": 6.57792106580953,

             "type": "Valid"

           },

           "warnings": []

         },

         "warnings": []

       }

     ],

     "_links": {}

    }