0 votes
1 view
in Azure by (15.1k points)

When should I use SQL Azure and when should I use table Storage? I was thinking, use table storage for transaction processing scenarios e.g. debit-credit accounts kind of scenario and use SQL Azure when data will not be used for transactional purposes e.g reporting. What do you think?

1 Answer

0 votes
by (41.2k points)
selected by
 
Best answer

There are multiple aspects which are there to be considered:

 

  • SQL Azure is relatively expensive for massive storage, does not scale super well and is limited to 150gigs/database, There are no transaction fees against SQL Azure and developers already know how to code against it.

 

  • ATS(Azure Table Services) is capable of mega-scalability, it is dirt cheap to store but gets expensive to frequently access. a significant amount of CPU power is required from nodes to manipulate. It basically forces to compute nodes to become mini-DB servers as the delegation of all relational activity is turned over to them.

 

  • frequently accessed data that does not need huge scalability and is not super large in size should be destined for SQL Azure, otherwise Azure Table Services.

 

  • For example, transactional data from financial transactions is a perfect place for ATS, while meta information (account profiles, names, addresses, etc.) is perfect for SQL Azure.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...