If i deploy a standalone Azure VM running SQL Server into an availavility zone; what will this achieve? Will i get two load balanced copies of the instance running from VM's out of two data centers in the zone with the data being synced? I think that is what the documentation is suggesting, but I cannot find any references which namecheck SQL Server specifically.
Surely if this is what is achieved it would be more widely publihsed as a valid way to achieve SQL Server HA without paying for the additional node (deploying a VM into an availability zone incurs no additional cost).
I have tried caryring out the deployment, and it works successfully but there is no information about which DC's within the zone are being used and i can't think of a way to test that i have H/A out of the box with no additional configuration required in SQL Server.
Can anyone offer any advice or point me in the direction of some good resource which covers this topic?
Thanks in advance!