what is best practice using Azure SQL Database ?

Question

what is best practice using Azure SQL Database ?

KIM 0

hi?

My customer decided to use Azure SQL Database.

In Azure, you can create and use multiple databases in one Azure SQL Database Server.

Is there any problem if I use it like this? Or do I need to create a SQL Server for each database?

The people who access each database are different, and each database is independent.

Currently, a single server is created and multiple databases are created and configured.

I wonder what the best practice configuration is in terms of Azure.

If anyone knows, please respond.

thank you!

Nikhil Mandaara 86 Reputation points

2024-05-23T20:30:47.2533333+00:00
Best practice for using Azure SQL Database depends on some factors

Security and Compliance: Is data isolation is critical, use separate server.

Workload: if it is a lightly used or dev databases, single server is more efficient.

Costs: If your goal is to save costs; single server is more cost effective when your resources are shared (elastic pool).

1 answer

Your answer

Nikhil Mandaara 86 Reputation points

2024-05-23T20:30:47.2533333+00:00

Best practice for using Azure SQL Database depends on some factors

Security and Compliance: Is data isolation is critical, use separate server.

Workload: if it is a lightly used or dev databases, single server is more efficient.

Costs: If your goal is to save costs; single server is more cost effective when your resources are shared (elastic pool).

Answer 1

Alberto Morillo 35,506 MVP Volunteer Moderator

If each database is independent, and cross-database queries are not common, Azure SQL is a perfect choice. No need to create a logical Azure SQL Server per database. One logical server is good enough. In case a database is accidentally deleted that logical server will allow you to recover it (undelete it).

0 comments

Share via

what is best practice using Azure SQL Database ?

1 answer

Your answer