CODEWITHSUNDEEP
azure-sql-databasesharding
ZafarYousafi
ZafarYousafi

Reputation: 10910

Windows Azure SQL database. Sharding Complete Tables to limit DB Size

I am moving my web app from on-premise to windows azure. In my app, I have two DBs which are setup on same SQL Server and so I can query one database from the other easily using fully qualified name in my query. Now moving to cloud, I am facing limitation where I can't query tables in One DB from another DB. I can't change my queries because it requires a complete change in web app. I was thinking to merge these DBs into one to save the web app rewrite. But my DBs are huge(40 GB each) and have heavy load(millions of hits per day). Now my question is,

Sorry If problem is vague and unclear.

Upvotes: 0

Views: 334

Answers (1)

Craig
Craig

Reputation: 36826

You also have the option of not using SQLAzure and use the new Azure IAAS where you can spin up a SQL Server instance that is closer to more traditional SQL Server. You can also control the instance size more easily this way. Here is some info http://blogs.msdn.com/b/windowsazure/archive/2013/04/24/sql-server-in-windows-azure-infrastructure-services-updated-documentation-and-best-practices-for-ga-upcoming-blogs.aspx

Upvotes: 1

Related Questions