I am using Microsoft SQL Server 2017 Web Edition in a virtualized environment hosted on Amazon EC2. Per Microsoft's Editions and supported features of SQL Server 2017 page, the "Maximum compute capacity used by a single instance - SQL Server Database Engine" is "Limited to lesser of 4 sockets or 16 cores."
Per Windows Task Manager in the virtual environment I have 4 virtual processors. But when I run a long-running, taxing SQL query the CPU utilization maxes out at 25%.
If the limitation for Web Edition is the lesser of 4 sockets or 16 cores, shouldn't I be allowed to use 100% of my virtual processors? Or am I misunderstanding how Windows or SQL Server is classifying virtual processors?