SQL Server 2017, 2019, and 2022 Standard or Enterprise software use a per core licensing model.
For more information, refer to the Microsoft SQL Server 2019 Licensing Models section in the SQL Server 2019 Licensing Datasheet https://download.microsoft.com/download/0/5/c/05c60185-ebdd-4472-895a-3d8e8da55682/SQL_Server_2019_Licensing_Datasheet.pdf.
All versions of Microsoft SQL Server Standard or Enterprise software use a per core licensing model. The SQL Server Express versions, however, do not require licensing. To determine the licensing needs for SQL Server Standard or Enterprise software that is installed on a Metasys Server:
- count the number of cores in the processor
- purchase the adequate number of core licenses
To assist you in counting the number of processor cores, refer to the specifications provided by the computer manufacturer or download the free Microsoft Assessment and Planning Toolkit (https://www.microsoft.com/en-us/download/details.aspx?id=7826). This toolkit may require the assistance from an IT professional. You may also consult the Microsoft Core Factor Table available at http://go.microsoft.com/fwlink/?LinkID=229882.
After you determine the number of processor cores, purchase the appropriate number of core licenses to allow the server-based Metasys host computers to access the SQL Server database. If the server-based Metasys host computers running SQL Server software has multiple cores in the processor, purchase one license for each physical core in the processor. For example, if the computer has a single quad-core processor, purchase four core licenses.
For a split ADX without the Metasys Advanced Reporting System, SQL Server software is installed only on the database server. You must purchase one core license for each physical core in the processor of the database server The web/application server does not require SQL Server CALs for Metasys.
For a split ADX with the Metasys Advanced Reporting System, the database engine component of SQL Server software is present on the database server, and the reporting services component of SQL Server software is installed on the web/application server. You must purchase one core license for each physical core in the processor for both the database server and the web/application server. If you install SCT on a Server class OS, the SCT machine will need a SQL license.
Table 1 lists the number of core licenses required based on the number of physical cores in the processor.
|
Physical Cores in the Processor |
Core Licenses Required (SQL Server Standard/Enterprise software requires a minimum of four core licenses, even for processors with less than four cores.) |
|---|---|
|
1 |
4 |
|
2 |
4 |
|
4 |
4 |
|
6 |
6 |
|
8 |
8 |