Which type of CPU for SQL Virtual Machine

CloudTech88 71 Reputation points
2021-02-03T03:59:09.117+00:00

We've got a client recently moved to Azure using Azure SQL Virtual Machine, 2019 with SQL standard. They're rather happy with setup except for 1 application which isn't playing well. Users are complaining about delays and sometimes timeout's when pulling particular reports from the application. The app vendor is looking into a few things to optimize their application on their side but we also noted the CPU will spike up really high when report is running which could be the problem.

We're going to adjust CPU for the day to determine if this is at fault or not. Current CPU is Standard D4s v3 (4 vcpus, 16 GiB memory)

Quite a rookie when it comes to SQL, anyone know which type of CPU would be best? maybe E-series? similar pricing point on E4s V4: 4Core 32GB.

CPU's listed here: https://azure.microsoft.com/en-us/pricing/details/virtual-machines/series/

SQL Server on Azure Virtual Machines
Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Navtej Singh Saini 4,221 Reputation points Microsoft Employee
    2021-02-04T02:05:46.117+00:00

    @CloudTech88

    Please go through this document for more information regarding the performance of Azure VM's. Please get back to us if you have further questions.

    I have also added the Sql Server general tag as well for more help.

    Regards
    Navtej S