Will I get charge per query on Azure SQL Database?

Lorenz Joseph Lavilla 20 Reputation points
2023-11-05T17:11:39.2666667+00:00

I have an application that's running query per second. Will it elevate the cost of my SQL Database?

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Andreas Baumgarten 107.5K Reputation points MVP
    2023-11-05T18:03:47.0033333+00:00

    Hi @Lorenz Joseph Lavilla ,

    the costs of an Azure SQL Database are based on:

    • Computer SKU (performance, vCPU, Memory)
    • Storage (to store the database)
    • Backup Storage (space you need for backups)

    There are no direct "number of transaction/query" based costs for Azure SQL Databases.

    Maybe this helps: Azure Pricing Calculator

    But at the end: The more queries you have per second the more compute performance you maybe need.


    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards

    Andreas Baumgarten

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Bruce (SqlWork.com) 63,741 Reputation points
    2023-11-05T17:30:36.1+00:00

    You are charged for storage size, bandwidth and cpu time, so yes the more queries the higher the charge. See pricing

    https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/

    note: you are charged the cpu cost of the queries, not the number.

    0 comments No comments

Your answer

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