When looking for the right VM for SQL we need to look at a lot of factors, but mainly these four factors Throughput of VM (Cached and Uncached)Cores AvailableVM Memory GNCost per month (compute and SQL license) This can be difficult to do as may current tools to pick a VM don't easily allow you … Continue reading Selecting the right Azure VM for SQL
Author: Bob Duffy
In a previous blog I talked about the new Esv5 Azure VM Types that looked very promising for SQL Server and data warehousing , perhaps unseating the older DSv2 that we had been recommending. https://prodata.ie/2021/11/03/the-new-king-vm-type-for-sql-has-arrived/ Now that we have upgraded a couple of customers from the 8 or 16 core DS to the equivalent Esv5 … Continue reading Azure SQL Performance Testing on ESv5 v DSv2