Stop/start schedule Azure SQL Managed Instance

Julie 100 Reputation points
2025-11-06T11:03:48.88+00:00

Hello,

I have a managed instance currently configured with 4 vCores, 64 GB storage, and local backups. I have configured the instance with a nightly stop/start schedule (from 11:00 pm to 06:00 am each day).

I would like to estimate the actual cost‐savings in our configuration, region, and purchasing model (pay-as-you-go) when applying this nightly schedule.

Do you have any information or advice?

Azure SQL Database
{count} votes

Answer accepted by question author
  1. Kalyani Kondavaradala 4,595 Reputation points Microsoft External Staff Moderator
    2025-11-10T13:57:49.58+00:00

    Hi Julie,

    Thanks for reaching on Microsoft Q&A!

    When you stop your Azure SQL Managed Instance, you won't be billed for compute and licensing costs during the time it's stopped. However, you will still incur costs for storage and backup storage. Since your instance stops at 11:00 PM and starts again at 6:00 AM, this gives you 7 hours of savings on compute costs each night.

    Here's a rough formula to help you estimate savings:

    1. Calculate the hourly cost of your instance:
      • Look up the pricing for the specific size (4 vCores) of your SQL Managed Instance in the Azure Pricing Calculator.
    2. Multiply the hourly rate by the number of hours you're stopping the instance:
      • Hourly Cost × 7 hours = Daily Savings
      • Daily Savings × 30 days = Monthly Savings
    3. Remember you will still be paying for storage and backup costs during those hours.

    https://azure.microsoft.com/en-in/pricing/calculator/ -->check for specific resource and you can calculate there.

    https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql&tabs=azure-powershell-prep%2Cazure-portal

    I hope this helps let me know if you need further help, happy to help you.

    Thanks!

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Marcin Policht 67,980 Reputation points MVP Volunteer Moderator
    2025-11-06T13:03:17.2966667+00:00

    For staters, consider what contributes to the cost in this case:

    1. Compute (vCore) chargesstopped instances do not incur compute (vCore) charges while in the stopped state. This is the primary source of savings from a nightly stop/start schedule.
    2. Storage charges (provisioned data storage) — continue to be billed while stopped.
    3. Backup storage & backup/retention charges — continue to be billed (local or long-term retention).
    4. Other fixed charges (e.g., networking egress, IP addresses) — generally continue if applicable.
    5. Licensing — included in the pay-as-you-go vCore rate, so pausing compute pauses that part of the charge.

    Inputs you need (get from Azure Pricing Calculator / portal):

    R = compute price per vCore-hour in Norway East (pay-as-you-go) — e.g., in USD/hour (or your billing currency)

    v = number of vCores (you said 4)

    S_GB = provisioned storage (GB) — you said 64 GB

    P_storage = storage price per GB-month (same region)

    P_backup = backup storage price per GB-month (if applicable)

    h_stop_per_day = hours stopped per day (you said 11:00 pm → 06:00 am = 7 hours)

    days_month = days in month (use 30 or exact month days)

    hours_month = 24 * days_month (typical use: 730 or 720; choose one)

    Formulas:

    Hours stopped per month: H_stop = h_stop_per_day * days_month

    Compute savings per month: Savings_compute = R * v * H_stop

    Compute what fraction of compute is saved: Pct_compute_saved = H_stop / hours_month (e.g., 210/720 = 29.17%)

    Net monthly cost change = (compute bill without schedule) − (compute bill with schedule) But since storage & backup continue, they aren’t changed:

    Compute_monthly_no_schedule = R * v * hours_month

    Compute_monthly_with_schedule = R * v * (hours_month - H_stop)

    Storage_monthly = P_storage * S_GB

    Backup_monthly ≈ P_backup * backup_GB (use your retained backup GB)

    • Total monthly savings = Savings_compute (since only compute changes).

    To get the accurate regional prices, you can use the following options:

    1. Azure Pricing Calculator — select Azure SQL Managed Instance (or your product), choose Norway East, Pay-as-you-go, and read the vCore/hour and storage per GB/month lines.
    2. Azure Portal / Cost Management — view current unit prices or your subscription’s meter rates (use actual invoices or the Cost Analysis blade to see meter rates).
    3. Azure RateCard / Pricing APIs — if you automate, use the Azure Retail Prices API or RateCard to programmatically pull unitPrice for your region/meter.

    There are some additional caveats to consider:

    1. Minimum/rounding billing increments: verify whether compute is billed in per-minute or per-second increments in that SKU (usually hourly-based rates are reported but charge may be prorated by the second). Use your invoice or cost API to confirm exact granularity.
    2. Start/stop automation timing — ensure stop occurs after all nightly jobs complete; a start during heavy load may cause performance/availability impacts.
    3. SLA/HA — frequent stop/start is fine for dev/test but may not be appropriate for production replicas or HA setups.
    4. Backup retention — long-term retention could add substantial monthly backup storage charges that are unaffected by stopping compute.
    5. Cold start latency — starting the instance reinitializes resources and may take time; plan windows accordingly.

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.