SQL Server on Amazon RDS vs SQL Server on Amazon EC2

  • Br. Kenneth Igiri

    SSCarpal Tunnel

    Points: 4521

    Comments posted to this topic are about the item SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    Br. Kenneth Igiri
    www.scribblingsage.com
    All nations come to my light, all kings to the brightness of my rising

  • curious_sqldba

    SSC-Dedicated

    Points: 36281

    Br. Kenneth Igiri - Wednesday, April 11, 2018 10:01 PM

    Comments posted to this topic are about the item SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    Perfect timing,  was just thinking about this.  In EC2 can you make the compute power flexible, like can you say I need  64 cores & 256 GB RAM during peak hours and off peak 16 cores to save some cost.

  • Br. Kenneth Igiri

    SSCarpal Tunnel

    Points: 4521

    curious_sqldba - Wednesday, April 11, 2018 11:16 PM

    Br. Kenneth Igiri - Wednesday, April 11, 2018 10:01 PM

    Comments posted to this topic are about the item SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    Perfect timing,  was just thinking about this.  In EC2 can you make the compute power flexible, like can you say I need  64 cores & 256 GB RAM during peak hours and off peak 16 cores to save some cost.

    Hello Curious. Thanks for the feedback. I am not sure about this for databases but you can do something like this with regular web servers or other server with static content used for processing workload. You can achieve this using Auto Scaling Groups. Auto Scaling Groups gives you flexibility to provide a range of instances you want to spin up (or "down") depending on thresholds you set such as CPU usage or memory usage etc. So let's say I start with 2 EC2 instances and specify a maximum of 8, the system will automatically launch new instances to support my workload when CPU exceeds 70% for example and shrink back to 2 during low peak periods.

    I have tried the above with Linux web servers running apache with their files sitting on S3. But I think there may be some quirks with servers in an AD Domain (same computer names) and of course database servers that need to keep data consistent.

    Br. Kenneth Igiri
    www.scribblingsage.com
    All nations come to my light, all kings to the brightness of my rising

  • mauriciorpp

    Default port

    Points: 1472

    what about performance? assuming EC2 and RDS with same cpu/ram settings, which option woud be faster?

  • Br. Kenneth Igiri

    SSCarpal Tunnel

    Points: 4521

    mauriciorpp - Sunday, April 15, 2018 12:04 PM

    what about performance? assuming EC2 and RDS with same cpu/ram settings, which option woud be faster?

    I have not simulated this so I may not be able to give an authoritative answer. However I do not expect the different to be significant.

    Br. Kenneth Igiri
    www.scribblingsage.com
    All nations come to my light, all kings to the brightness of my rising

  • mauriciorpp

    Default port

    Points: 1472

    Br. Kenneth Igiri - Sunday, April 15, 2018 2:27 PM

    mauriciorpp - Sunday, April 15, 2018 12:04 PM

    what about performance? assuming EC2 and RDS with same cpu/ram settings, which option woud be faster?

    I have not simulated this so I may not be able to give an authoritative answer. However I do not expect the different to be significant.

    I would assume RDS is expected to be slightly faster, because of optimizations we count that AWS will apply at the server level. For EC2 instance, the one configuring SQL server must know what he/she is doing to make optimal use of the hardware.

    But if you can run some queries for benchmarking it just to make it clear to anyone doing research on this topic, it would be great. 🙂

  • curious_sqldba

    SSC-Dedicated

    Points: 36281

    Br. Kenneth Igiri - Wednesday, April 11, 2018 10:01 PM

    Comments posted to this topic are about the item SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    Were u ever able to successfully set up AG in EC2. I was able to get 90% of it working, i ran into issues when assigning cluster ips to nodes.

  • Br. Kenneth Igiri

    SSCarpal Tunnel

    Points: 4521

    curious_sqldba - Tuesday, April 24, 2018 11:52 AM

    Br. Kenneth Igiri - Wednesday, April 11, 2018 10:01 PM

    Comments posted to this topic are about the item SQL Server on Amazon RDS vs SQL Server on Amazon EC2

    Were u ever able to successfully set up AG in EC2. I was able to get 90% of it working, i ran into issues when assigning cluster ips to nodes.

    Haven't try that though. will take a look and share.

    Br. Kenneth Igiri
    www.scribblingsage.com
    All nations come to my light, all kings to the brightness of my rising

Viewing 8 posts - 1 through 8 (of 8 total)

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