Hosting SQL Server 2016 or 2019 in Private IaaS

Question

Hi,
We have a private cloud based on Docker EE. SQL Server 2016 is the defacto database for several applications. For several reasons the applications need to stay in Private IaaS environment, and cannot go to Azure yet.
So we have two options:
( 1 ) Option 1: SQL Server 2016 or 2019 in Always-On cluster
( 2 ) Option 2: SQL Server 2016 or 2019 running in Docker

What is the best option from SLA, maintenance, cost point of view? Please let me know..

Thanks.

Answer 1

You asked a question about SQL Server in a Windows Server forum. If you wish to reach SQL experts who are more qualified to answer your question, you may want to ask in a SQL forum like https://social.technet.microsoft.com/Forums/en-US/home?forum=sqldisasterrecovery

Answer 2

@MoinakBhattacharya-9823 Thank you for reaching out.

SQL Server and On-prem set up are not supported on Microsoft Q&A.
Please post this issue on MSDN where we have a dedicated forum for SQL Server and Windows Server.

Answer 3

Hi,

Thank you for coming Microsoft Q&A forum. According to your description, seems like your issue is more related with SQL server, please contact with SQL server forum for more information.

Bests,