Azure Table Storage Vs. SQL Azure

At the time of application design decision on Azure, most of us get into this discussion at some point in time, “Table Storage OR SQL Azure”.

I thought of listing down the pros and cons for both of these storage options. Following comparison might be helpful to drive the decision.

List down the expectations from the desired storage from application point of view and compare those requirements with the help of following table.

Table Storage

SQL Azure

Pros

Cons

Pros

Cons

Provides scalability out of the box and supports approximate ~ 100TB storage Every transaction (CRUD operation) is charged within the platform which might accumulate higher charges for high volume transactional systems Transactions within the platform are not charged Doesn’t provide scalability out of the box and there is a hard limit of 50 GB per database instance. Application need to handle the partition logic

much more here from Sachin Prakash Sancheti

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • MisterWong
  • Y!GG
  • Webnews
  • Digg
  • del.icio.us
  • StumbleUpon
  • Reddit
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • XING

Leave a Reply