CODEWITHSUNDEEP
sqldatabaseperformanceazureazure-sql-database
Eric Yin
Eric Yin

Reputation: 8983

SQL-Azure Performance, Add Database or Add Server?

This is not a traditional scale-up or scale-out question.

Please bear with me, here first allow me give an example:

I created a Sql Azure server and create a 1GB database inside, cost $9.99 a month. (It has a master database as well, 1G, but Microsoft not charge us for that)

Ok, here is my question comes, when I need another 1G database for my application. Why I need another 1GB database? You may ask me this because the azure can support database up to 50GB. My answer is distribution, I know the data will reach 50G eventually, so I create the data model distribute and spread the data in different database.

For all the sake of performance, which option I should use:

  1. Create another database in same server
  2. Create another server and create a new database inside

Both option cost same. I guess option 2 will be better, isn't it?

Upvotes: 2

Views: 865

Answers (1)

Yossi Dahan
Yossi Dahan

Reputation: 5357

I'm not sure there are strong (or any) performance implications, my understanding is that the consideration is mostly a management one as some entities, mostly around security, are defined at server level and some at database level.

Behind the scenes the model is quite different anyway, and a multi-tenant one, so having separate SQL Azure server does not actually mean you get a dedicated server per-se. theoretically separate servers or separate databases may end up looking exactly the same.

Upvotes: 4

Related Questions