Last post Jul 28, 2016 01:37 PM by Chris Zhao
Jul 27, 2016 10:52 AM|skliz4rel|LINK
I am new to Azure. So I just built an high level application that runs a search directory with about 19 other business modules and high level payments.
My server is high to require a very I load of traffic so I have come to seek opinions of the experts which way do I create my sql db on Azure.
I have tried the quick create but I was adviced by a fellow on this forum to go for Virtual machine running full scale SQL server based on draw backs of azure sql in certain instances.
I saw someting like SQL Server 2016 WebWindows Server 2012 R2 in
the gallery is this the best option for me based on my application requirements
Thanks alot, Please I am open to advice
Jul 28, 2016 09:49 AM|Janshair Khan|LINK
Choosing between SQL Database (DaaS) and SQL Server in VM depends upon your situation. You can get decide based upon the following factors that which one to choose:
SQL Server in a VM requires more control and administrative responsibility than SQL Database. In SQL Server in a VM, if your business requires a lot of data, then it might be the highest possible image for an Azure VM i.e. A VM with VM with 8 virtual
CPUs, 14GB of RAM, 16 TB of storage, and 800 MB/s network bandwidth.
In SQL Database (DaaS), you don't have to worry about the underlying hardware, instead you can have a DaaS service with maximum 500GB, you have to spin a new instance of your server if your requirement exceeds this limit.
Hope it will help you to decide which one to choose.
Jul 28, 2016 01:37 PM|Chris Zhao|LINK
Taka a look at Choose a cloud SQL Server option: Azure SQL (PaaS) Database or SQL Server on Azure VMs (IaaS). This article explored SQL Database
and SQL Server on Azure Virtual Machines (VMs) and discussed common business motivators that might affect your decision.
SQL Server in an Azure Virtual Machine