Finding Number of Virtual Cores Assigned to SQL Guests

SQL Server Administration
1

Hi experts,
We are inventorying our SL licenses.
I've been asked to determine:
Nbr of physical cores on each SQL Server - easy enough to do

Nbr of VIRTUAL cores that are assigned to SQL Guests - can I query to get this value?

Thanks for any tips.

2

I did a simple google search for 'SQL Server query logical processors' and came up with multiple sites that shows how to get both logical and physical.

All the information you need is in sys.dm_os_sys_info

1 Like
3

This has exactly what you need.