create separate sql server for each DB instance

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?

Answer 1

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. 

Answer 2

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

Answer 3

Yes, you will have to pay for 2 servers.

Answer 4

there is no charge for creating sql servers

the charge comes from creating databases

Answer 5

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.

 

Answer 6

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

or

multiple sql servers with single DBs

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