November 24, 2024 at 5:42 pm
Hello ,
I'm having an issue with a SQL Server VM that has 30 vCPUs allocated. However, in the server affinity configuration, when I check the "Affinity Mask", it detects only 19 vCPUs.
Can someone explain to me why there is a difference between the number of vCPUs allocated to the VM and the number detected in the affinity configuration? Is this a configuration issue or is there a limitation of SQL Server or the VM itself
Thank you for your help
Thanks
November 24, 2024 at 7:55 pm
what does the SQL Logs say about licensing and allocated cores? Could be limited by license applied.
and what is the VM type - some config there may be wrong - but never seen sql not use the cpus except by license restrictions.
November 29, 2024 at 6:47 am
Thank you for sharing this information...
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy