Hi Ancy Thank you for reaching out.
My understanding is that you are looking for the best database for your scenario described above. A database that will provide real time data operations and speed read and write operations.
Azure offers several types of databases to meet different application needs. To list few of them
- Azure SQL Database
- Azure Cosmos DB
- Azure Database for MySQL
- Azure Database for PostgreSQL
- Azure Synapse Analytics
- Azure Cache for Redis
- Azure Table Storage
Adding on top of Vahid Ghafarpour and @Alberto Morillo
Choose Azure Cosmos DB if:
You are looking to manage real-time operations in Azure. Azure Cosmos DB is a globally distributed, multi-model database service designed for low-latency, high-throughput applications that require real-time data access.
In addition, Azure Cosmos DB is well-suited for IoT (Internet of Things) applications that generate a massive volume of data in real-time. It can handle the ingestion and processing of sensor data, telemetry data, and event streams with low latency.
Choose SQL Server in Azure VMs if:
You are looking to "lift and shift" your database and applications with minimal to no changes.
You prefer having full control over your database server and the VM it runs on.
You already have SQL Server and Windows Server licenses that you intend to use.
Choose Azure SQL Database if:
You are looking to modernize your applications and are migrating to use other PaaS services in Azure.
You do not wish to manage your database server and the VM it runs on.
You do not have SQL Server or Windows Server licenses, or you intend to let licenses you have expired.
Pricing:
It's important to evaluate your specific workload requirements, performance needs, and data storage needs when considering pricing. Azure offers a pricing calculator that can help estimate the costs for different database services based on your requirements. Additionally, regularly monitoring and optimizing your database usage can help control costs and ensure you are only paying for the resources you need. Azure cost Management.
I recommend applying for the AMMP program, which will help you get a free guidance and analysis. Azure.com/ammp
Please do let us know if you want to learn more about the above databases. I can provide you with more details.
Please do not forget to mark as accept answer wherever information provided were helpful.
Regards,
Oury