Launching AWS SQL Server RDS

Business Needs:

Our goal is to identify whether Amazon SQL Server RDS Service provides elastic , highly available , Scalable and operationally efficient solution for our use case. We are evaluating options to migrate our read/write heavy production SQL Server database to amazon SQL Server RDS. We have pretty high throughput needs for few hours a day for few months in a year ,which is mission critical for our business success. Any downtown during peak usuage would be catastrophic for our business. We are evaluating pros and cons of moving to amazon RDS with provisioned IOPS.

Caveats of AWS RDS SQL Server:

These information we gathered while working with SQL Server RDS.

Feature NameYes/NoDescription
SQL Server 2016 SupportNoMicrosoft says SQL Server 2016 comes with very rich feature set and ton on OLTP Enhancements
Native Backup RestoreYesAWS RDS Released this feature a week ago , which makes moving databases across environments lot more easier.
Elastic IOPSNoStorage and IOPS needs to be incremented linearly for higher performance. You can’t get higher IOPS without increasing storage.
Elastic StorageNoScaling Storage is not an option after launching an instance
RAID SupportNoWe usually have RAID 10 for production workload and RDS doesn’t have options to configure RAID
Point in Time Restore on Same InstanceNoYou can’t do Point in Time Restore on the existing database. You have to spin up new Instance
AlwaysOn Availability GroupsNoThis provides ability to failover group of databases to your secondary instance
MirroringYesMirroring is Deprecated feature and its replaced with AlwaysOn Availability Groups
Linked Servers from RDSNoBut Linked Servers to RDS is Allowed.
Service BrokerNoComes handy for services

  No Admin privileges. You can’t execute normal sql server system stored procedures and you need to work with options groupand parameters group to modify configuration. You can’t execute sp_configure to change configurations.

Share this:

Want help modernizing

your applications?

Let’s Talk

    CloudIQ is a leading Cloud Consulting and Solutions firm that helps businesses solve today’s problems and plan the enterprise of tomorrow by integrating intelligent cloud solutions. We help you leverage the technologies that make your people more productive, your infrastructure more intelligent, and your business more profitable. 


    3520 NE Harrison Drive, Issaquah, WA, 98029


    Chennai One IT SEZ,

    Module No:5-C, Phase ll, 2nd Floor, North Block, Pallavaram-Thoraipakkam 200 ft road, Thoraipakkam, Chennai – 600097

    © 2022 CloudIQ Technologies. All rights reserved.

    Get in touch

    Please contact us using the form below


      3520 NE Harrison Drive, Issaquah, WA, 98029

      +1 (206) 203-4151


      Chennai One IT SEZ,

      Module No:5-C, Phase ll, 2nd Floor, North Block, Pallavaram-Thoraipakkam 200 ft road, Thoraipakkam, Chennai – 600097