SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Peter Marriott
Peter Marriott
Old Hand
Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)

Group: General Forum Members
Points: 355 Visits: 109
Comments posted to this topic are about the item Is it time to move from SQL Azure to Amazon RDS SQL Server?
tomski_boy
tomski_boy
SSC Veteran
SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)

Group: General Forum Members
Points: 207 Visits: 42
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.
irozenberg
irozenberg
SSC Veteran
SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)

Group: General Forum Members
Points: 202 Visits: 145
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).
Roshan Jospeh
Roshan Jospeh
SSCarpal Tunnel
SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)

Group: General Forum Members
Points: 4955 Visits: 2102
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
Peter Marriott
Peter Marriott
Old Hand
Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)

Group: General Forum Members
Points: 355 Visits: 109
Hi Roshan Joe,

Thank you yes I plan to get to that in the next few weeks.
Peter Marriott
Peter Marriott
Old Hand
Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)

Group: General Forum Members
Points: 355 Visits: 109
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.
Peter Marriott
Peter Marriott
Old Hand
Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)

Group: General Forum Members
Points: 355 Visits: 109
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.
nitin.lokhande
nitin.lokhande
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 40
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
liebesiech
liebesiech
SSC Eights!
SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)SSC Eights! (982 reputation)

Group: General Forum Members
Points: 982 Visits: 868
Cannot federation help to overcome the 150GB limit?
Peter Marriott
Peter Marriott
Old Hand
Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)Old Hand (355 reputation)

Group: General Forum Members
Points: 355 Visits: 109
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search