Launching AWS SQL Server RDS
AWS
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 Name | Yes/No | Description |
| SQL Server 2016 Support | No | Microsoft says SQL Server 2016 comes with very rich feature set and ton on OLTP Enhancements |
| Native Backup Restore | Yes | AWS RDS Released this feature a week ago , which makes moving databases across environments lot more easier. |
| Elastic IOPS | No | Storage and IOPS needs to be incremented linearly for higher performance. You can’t get higher IOPS without increasing storage. |
| Elastic Storage | No | Scaling Storage is not an option after launching an instance |
| RAID Support | No | We usually have RAID 10 for production workload and RDS doesn't have options to configure RAID |
| Point in Time Restore on Same Instance | No | You can't do Point in Time Restore on the existing database. You have to spin up new Instance |
| AlwaysOn Availability Groups | No | This provides ability to failover group of databases to your secondary instance |
| Mirroring | Yes | Mirroring is Deprecated feature and its replaced with AlwaysOn Availability Groups |
| Linked Servers from RDS | No | But Linked Servers to RDS is Allowed. |
| Service Broker | No | Comes 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:
Take a look at the lastest aricles
Executive Summary Crystal Reports is aging out. Talent is shrinking. The modern stack has moved on. Yet migration projects stall because they are manual, error-prone, and slow. This article introduces a multi-agent AI pipeline — six specialist agents, each evaluated before advancing — that automates the Crystal-to-Power BI conversion end to end. Six Agents, Six […]
Seattle – [Mar23, 2026] – CloudIQ Technologies Inc today announced it has earned the AI Apps on Microsoft Azure specialization, a validation of a solution partner’s deep knowledge, extensive experience, and proven expertise in designing, developing, and deploying AI-powered applications on Microsoft Azure. Only partners that meet stringent criteria around customer success and staff skilling, […]
An SRE Perspective on Circuit Isolation, Fallback Traffic & Reliability Control Engineering resilience into a system is only half the story. Operating it under real-world load is the other half. A distributed cache protected by circuit breakers and automatic fallback is a powerful architectural construct. But from a DevOps and SRE perspective, the critical questions […]
Let’s shape your AI-powered future together.
Partner with CloudIQ to achieve immediate gains while building a strong foundation for long-term, transformative success.