2-tier database server/web server

Chelsea Haddad 21 Reputation points
2022-10-11T07:29:06.44+00:00

I need to know what are the best VM types to use. If I choose to use a memory-optimized VM, the DS12_v2, for my database server, can I use a general purpose VM for my web server? If so, what's the optimal one?

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,266 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. msrini-MSFT 9,261 Reputation points Microsoft Employee
    2022-10-11T08:43:45.467+00:00

    Hi,

    Yes you can choose General Purpose SKUs for your Web Server. Within General Purpose bucket, the size is something you can choose based on your scenario like how much traffic you are expecting and what is the min and max CPU you need, etc.

    You can also try this https://aka.ms/vm-selector VM Selector tool which will recommend few Sizes which best suits you.

    Regards,
    Karthik Srinivas

    1 person found this answer helpful.

  2. Abraham Glover 1 Reputation point
    2022-10-11T15:54:40.253+00:00

    To be honest, it is worth investigating AzureSQL at least for an initial PoC (proof of concept), it could give you a good indication of what is needed for your VMs without the guest work.
    Without some specifics or your read/write and the size of the database it is hard to suggest a good sizing.

    0 comments No comments