SQL Services: Tips and Tricks for High Throughput

How tobuild high performance apps in the cloud.



The ace concepts:
ACE model in SQL services
A for authority
C for container
E for entity

Authority is your instance I azure
Container is the database
Entity is the record in a table








All fields of an entity are indexed.

Uses c# linq syntax for query.




Using multiple containers help with performance.

How does data access works?
Processing of queries works in parallel.

You can add multiple threads to run a single query across multiple comtainers.

Multiple updates:
Uses version numbers of entities to handle concurrency.



Demo of windows azure service hosting.

2 out of 2 demos failed.




There is support for batch processing.

Dropped out after last demo failed.