sql-serverazure-sql-databaseazure-elastic-scale

Hash Shard Map with SQL Azure

I've been doing some reading about sharding SQL Azure databases with Azure Elastic Scale. The article discusses two types of shard maps: List and Range. What about Hash shard maps? My application requirements are to evenly distribute data across shards which would seem to require a hashing of the shard key. Is this possible with SQL Azure and Azure Elastic Scale?

Solution

  • At this point in time Elastic Database tools (formerly known as Elastic Scale) doesn't support hash shard maps.

    Thanks

    Silvia Doomra