load balancing sql azure databases

  • Im trying to set up a demo to play with load balancing of azure sql databases.

    I set up my cloud service and endpoint, added both sql databases as linked resources but have hit a wall.

    Ive also struggled to find documentation on this, with most documentation being how to load balance VM's.

    Can anyone point me to an article/blog on configuring load balancing sql databases?

  • This is not something I've attempted myself, but there is documentation on how to set it up available on MSDN. That includes a step by step process along with the Powershell scripts to make it happen.

    I suspect you also have to set up sharding on your databases, but I'm not sure about that.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Thanks grant, thats what i needed.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply