Hi @Vishu ,
> would it be on the basis of total cores or logical processors(Threads)
It would be on the basis of the total cores. If you choose Per Core Based Licensing , when running SQL Server in a physical environment, licenses must be assigned to all of the physical cores on the server. A minimum of four core licenses per physical processor are required, with licenses being sold in packs of two.
Example 1 – The SQL Server has two processors, each with six cores:
- Ascertain how many cores there are per processor (keeping in mind the minimum requirement of four cores per processor)
- Count the total number of cores
- A total of twelve cores are present, therefore 6 SQL Server Per Core licenses (packs of 2) are required
Refer to the blog An Introduction to Microsoft SQL Server Licensing Or MS blog Microsoft SQL Server 2019 Licensing guide .
If you have further SQL license issues, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. Or you can go to Volume Licensing Service Center support. Please choose region/language and choose to call or have web. People there will help you more effectively.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.