Share via

Azure sql database setup

MikeZheng-3371 46 Reputation points
2022-01-21T20:01:18.123+00:00

Hello,

I am new to Azure. We are planning to use Azure SQL database on the cloud. We expect to have about 10TB data. Most applications are OLTPs with JSON file in the column of tables. Would you please let me know what is recommended configuration should I use? For example, Azure SQL database on VM, Azure SQL database or Azure SQL managed instance? Blob storage or Data lake? Cost model and etcs?

Thanks,

Mike

Azure SQL Database
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator
    2022-01-21T20:36:53.117+00:00

    All you need is contained on this documentation. This a full comparison between Azure SQL, Azure Managed Instance and Azure SQL VM, that are the real options suitable for OLTP workloads. Let me know if you need further information.

    About pricing, Azure SQL Hyperscal support up to 100 TB databases and the pricing can be found here. Azure SQL Managed Instance (General Purpose) supports 16 TB and the pricing can be found here. For SQL Server VM pricing please visit this documentation, and maximum storage is 16 TB but you can extend that to 100 TB using SMS network shares.

  2. Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator
    2022-01-24T18:09:27.517+00:00

    Hi @MikeZheng-3371 Thank you for posting your question on Microsoft Q&A.

    In addition to @Alberto Huaranga Mateo 's answer
    If it’s a migration, it’s going to depend on what you were using in SQL Server before. E.g. – do you have third party apps that need access to the OS? If so I will suggest Azure SQL on VM.
    Do you use SQL Server instance scoped features (Database mail, service broker, ML services, SQL Server Agent, etc) If so SQL MI will be a good option. OTHERWISE, the best place to land will likely be Azure SQL Database Hyperscale.

    I recommend you to apply for the AMMP program, which will help you get free guidance and analysis. Azure.com/ammp

    Please do not forget to mark as accepted answer if the reply was helpful. It will be beneficial for other community members.

    Regards,
    Oury

  3. Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator
    2022-01-26T23:00:19.867+00:00

    Hi @MikeZheng-3371 Thank you for your question
    If the third-party apps need access OS, is the Azure SQL on VM the only choice?
    With PaaS services, you don’t have access to the OS. If you want to move to PaaS, you will have to re-work your app/relationship to third party, since you will not have access to OS.

    We're going to have Microsoft Dynamics next year. Is it an issue using Azure SQL DB?
    It is not going to be an issue Is it for dynamics NAV??

    Hope that helps

    Regards,
    Oury

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.