create separate sql server for each DB instance RRS feed

  • Question

  • Hi

    i thought i read somewhere that if using an enterprise agreement it was the same price to create a new sql server for every DB as it would be to create multiple DBs on 1 sql server.

    I doubt this is the case but would just like to be sure?

    Friday, May 29, 2020 2:31 PM

All replies

  • Sorry for the delay in response to your query.

    If you create multiple databases on a singe SQL server, you will only be charged for that 1 server. That being said, you will billed for the SQL server irrespective of number of databases on that server.

    Hope this answers your question!

    If this answer was helpful, click “Mark as Answer” and Up-Vote. Feel free to reach out to us if you've any further questions in this matter. 

    Monday, June 1, 2020 7:53 AM
  • Hi

    Thank you for the reply

    if i create 2 sql servers do i pay for 2 

    i was told that under the agreement it didn't matter who many servers were created

    Monday, June 1, 2020 12:07 PM
  • Yes, you will have to pay for 2 servers.
    Monday, June 1, 2020 2:25 PM
  • there is no charge for creating sql servers

    the charge comes from creating databases

    Friday, June 5, 2020 1:51 PM
  • Is this question related to pricing for SQL Server on a VM or Azure SQL?

    For SQL Server on a VM, the license is per core or per server depending on Edition of SQL Server. More details here

    So you can host multiple databases on a single physical/virtual server without any additional cost.

    If your question is regarding Azure SQL, then the pricing is per database. You can choose to host one database per server or multiple databases on the same server. 

    Either ways, you can scale and manage them individually.


    Monday, June 8, 2020 7:03 AM
  • Sorry yes Azure SQL

    so if no cost for creating a sql server and cost is per database 

    is it best practice to create single server with multiple DBs


    multiple sql servers with single DBs

    is it better for performance etc for multiple servers so other DBs cant affect each other

    Monday, June 8, 2020 8:14 AM