Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Definition of hyperthreading and Logical processor and VMware for SQL licensing

Posted on 2014-02-04
1
Medium Priority
?
1,002 Views
Last Modified: 2014-02-08
Hello there,

Because of the recent change in licensing model of MS SQL licensing from per proc to per core. We have quite a few SQL servers hosted in ESX hosts.

How deos hyperthreading in use and Logical processors contribute towards calculating number of cores per VM?

And is Dynamic Workload management same as DRS?

Please advise.

Thanks and Regards
0
Comment
Question by:goprasad
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 39832995
"Hardware Thread
A hardware thread is either a physical core or a hyper-thread in a physical processor."

From http://www.google.ca/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=1&cad=rja&sqi=2&ved=0CCYQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F7%2F3%2FC%2F73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00%2FSQL_Server_2012_Licensing_Reference_Guide.pdf&ei=GxbxUpe0H8Tr2QXwjoDgCw&usg=AFQjCNHdiY7wTdgDJKB9TgNDmeZr1A7BbA


More clarifications here:
http://www.mssqltips.com/sqlservertip/2942/understanding-the-sql-server-2012-licensing-model/

"Note that hyper threading is ignored for core licensing purposes when licensing physical servers. The same does NOT apply to VMs - see the section below!" - check  Core factor at link above.
0

Featured Post

Cyber Threats to Small Businesses (Part 2)

The evolving cybersecurity landscape presents SMBs with a host of new threats to their clients, their data, and their bottom line. In part 2 of this blog series, learn three quick processes Webroot’s CISO, Gary Hayslip, recommends to help small businesses beat modern threats.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Teach the user how to configure vSphere clusters to support the VMware FT feature Open vSphere Web Client: Verify vSphere HA is enabled: Verify netowrking for vMotion and FT Logging is in place or create it: Turn On FT for a virtual machine: Verify …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question