[james_anderson]

Haha, thanks for your answer Brent. I think you're right about VMs. SQL Server on docker in prod is kind of a thought experiment of mine at the moment.

I'd love to hear from anyone who is even just thinking of doing this.

> dynamically adding Always On Availability Group read-only replicas

Yeah I doubt scaling SQL Server out dynamically will ever make monetary sense, but it might be cool to just get it working.

I'm thinking of creating a Helm chart for K8s that allows you to dynamically scale the SQL Server pod up and down. I think I'll need to use some undocumented DBCC commands (or call the API) to freeze IO, so I can replicate the data files to the new secondary as it spins up.

Horizontally scaling SQL Server would be cool. Maybe if the hosts were licensed so we could run as many containers as we wanted, it could make sense...