Is it time to move from SQL Azure to Amazon RDS SQL Server?

  • Comments posted to this topic are about the item Is it time to move from SQL Azure to Amazon RDS SQL Server?

  • Great Article Peter, However It would have been good to do a performance benchmark between Azure and Amazon RDS using the same Database (loaded with sample data to different size points) and apply a work load file against it.

    From Experience Azure seems average for speed but makes it rather hard to connect to as a non developer. The fact that Amazon RDS connects simply with SSMS is a great selling point for me, but at what cost (i.e security). Not to mention most Amazon services have a high network latency (from Sydney Aus) compared to Azure.

  • G'day. Why you did not even consider an option to move from SQL Azure to WinServer/SQL VM in cloud as part of Microsoft Azure IaaS recent offer (announced in beginning of June).

  • Thank you for the wonderful article.

    Looking forward to hear more on performance

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Hi Roshan Joe,

    Thank you yes I plan to get to that in the next few weeks.

  • tomski_boy (7/10/2012)


    Great Article Peter, However It would have been good to do a performance benchmark between Azure and Amazon RDS using the same Database (loaded with sample data to different size points) and apply a work load file against it.

    From Experience Azure seems average for speed but makes it rather hard to connect to as a non developer. The fact that Amazon RDS connects simply with SSMS is a great selling point for me, but at what cost (i.e security). Not to mention most Amazon services have a high network latency (from Sydney Aus) compared to Azure.

    Thank you, yes I am about to do some benchmarking for a client comparing the performance of both Azure and AWS. I intend to run a few different VM sizes for both and with AWS I will be able to try different sizes of database server. We’re hoping we’ll get permission to share the results back via a follow-up article.

    Definitely being able to connect into RDS via SSMS from anywhere will be a big selling point for many people. It’s a matter of getting the best compromise between convenience and security.

  • irozenberg (7/10/2012)


    G'day. Why you did not even consider an option to move from SQL Azure to WinServer/SQL VM in cloud as part of Microsoft Azure IaaS recent offer (announced in beginning of June).

    The great thing about the existing PaaS offering from Azure - and to a lesser degree RDS - is the outsourcing of the high availability, DR and maintenance. For this particular application that was what took us away from IaaS using Amazon EC2 initially.

    That’s not to say we wouldn’t use IaaS in other situations. Actually we’re currently looking at it as a possibility for a different project.

  • As i understand that if u are having backup of snapshots and wanted to restore, u need same setup. during DR period how can make same setup.

    correct me if i aim wrong.

    Thanks

    Nitin

  • Cannot federation help to overcome the 150GB limit?

  • liebesiech (7/11/2012)


    Cannot federation help to overcome the 150GB limit?

    Yes it can, but from what I have seen it isn't very nice to use and you have to change your code.

  • You can connect to SQL Azure with SSMS with an encrypted connection from any machine.

  • Peter Marriott (7/11/2012)


    liebesiech (7/11/2012)


    Cannot federation help to overcome the 150GB limit?

    Yes it can, but from what I have seen it isn't very nice to use and you have to change your code.

    I thought so! Thanks for your quick reply!

  • nitin.lokhande (7/11/2012)


    As i understand that if u are having backup of snapshots and wanted to restore, u need same setup. during DR period how can make same setup.

    correct me if i aim wrong.

    Thanks

    Nitin

    Hi Nitin,

    Not quite sure I follow. For AWS you can restore either one of the automated backups or a snapshot you have created. However you restore it on to a different AWS machine and you will have to change connection strings to point to the new database server. The different machine can be specified as a different version and size. But I have only ever restored databases to the same power and license type.

    Does that answer your question?

  • nitin.lokhande (7/11/2012)


    As i understand that if u are having backup of snapshots and wanted to restore, u need same setup. during DR period how can make same setup.

    correct me if i aim wrong.

    Thanks

    Nitin

    Hi Nitin,

    Not quite sure I follow. For AWS you can restore either one of the automated backups or a snapshot you have created. However you restore it on to a different AWS machine and you will have to change connection strings to point to the new database server. The different machine can be specified as a different version and size. But I have only ever restored databases to the same power and license type.

    Does that answer your question?

  • chadgronbach (7/11/2012)


    You can connect to SQL Azure with SSMS with an encrypted connection from any machine.

    Yes you can if you have opened up the Azure SQL Database firewall to let that machine in.

Viewing 15 posts - 1 through 15 (of 39 total)

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