We're currently hosting our SQL Server instances on AWS VMs. I was recently hired as a data architect and DBA. I'd like to move our instances to either managed services using AWS RDS or Azure SQL. I was told by our current CTO the following:
After having actually managed all this for several years now, I disagree [about the benefits of moving to a Platform-as-a-Service (PaaS) model]. I actually have experience with both "cloud managed" (on both AWS and Azure) and "self managed" and I have real concerns about performance (mostly I/O) on PaaS platforms. The level of flexibility and ability to tailor storage exactly how we need is something we just can't do with the PaaS services. With the ease of use, you lose almost all customization capability.
For those of you with experience using AWS RDS or Azure SQL, do we actually lose almost all customization capability? Most of our databases are under 1TB. In fact, I think our largest is currently at 680GB. Also, as an FYI, my colleague's greatest concern seems to be the performance gap between a managed environment and an instance sitting on a VM. The ease with which you can scale resources would seem to alleviate this concern.
Also, if this isn't the appropriate forum for a question like this, I would be glad to move it, if someone can tell me a more appropriate forum.