Share via

How to expand my db for more markets ?

Siva 0 Reputation points
2024-12-16T15:51:16.31+00:00

Right now SQL server db is running in one region and right now we have enabled solution for one market, in future we need to roll out for more markets and need to run in multiple regions . When we enable more markets we will millions of records . can you suggest us , how we can handle this use cases?

Thanks,

Siva

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,223 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Azar 24,685 Reputation points MVP
    2024-12-16T17:57:49.9366667+00:00

    Hi there Siva

    Thanks for using the QandA platform

    Tryr enabling Active Geo-Replication in Azure SQL db to distribute workloads and ensure high availability across regions. do data partitioning. Use elastic pools in Azure SQL for cost-effective management of multiple databases with varying workloads. For read-heavy scenarios, deploy read replicas in different regions to reduce latency. Scaling out horizontally or vertically and considering distributed databases like Azure Cosmos DB for global distribution can further enhance performance and reliability for your expanding needs.

    https://zcusa.951200.xyz/en-us/azure/azure-sql/database/failover-group-sql-db?view=azuresql

    https://zcusa.951200.xyz/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql&tabs=tsql

    If this helps kindly accept the answer thanks ,much.

  2. Erland Sommarskog 114.6K Reputation points MVP
    2024-12-16T22:44:16.7166667+00:00

    This question is far too vague to be possible to answer. Obviously, when your business and your data grows, you can face challenges, all depending on good your original database design was.

    Do deal with this situation, you need to learn about performance troubleshooting. A good source is the book SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques by Dmitri Korotkevitch. For full disclosure, I should say that Dmitri is a good friend of mine, and I was the tech reviewer of the book.

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.