# SQL Server Cost Calculator for a SyteLine On-Prem Landscape

> Source: https://netray.co/tools/syteline-sql-server-core-licensing-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Counts the core licences and 2-core packs a per-VM SQL Server licensing model needs for SyteLine, then applies your price and Software Assurance rate over several years.

## Category

syteline

## Erp

Infor SyteLine

## Audience

- IT manager
- ERP administrator
- CIO
- Infrastructure architect

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Production SQL Server VMs

**Key:** prod_vms

**Type:** number

**Default:** 1

**Min:** 0

**Step:** 1

#### vCPUs per production VM

**Key:** prod_vcpu

**Type:** slider

**Default:** 8

**Min:** 1

**Max:** 64

**Step:** 1

#### Non-production VMs needing paid licences

**Key:** np_vms

**Type:** number

**Default:** 0

**Min:** 0

**Step:** 1

**Help:** Dev and test that are not production use may run Developer edition; check your agreement.

#### vCPUs per non-production VM

**Key:** np_vcpu

**Type:** number

**Default:** 4

**Min:** 1

**Step:** 1

#### Price per 2-core pack

**Key:** pack_price

**Type:** number

**Default:** 0

**Min:** 0

**Step:** 100

**Help:** Enter your quoted price for the edition you buy. No default price is assumed.

#### Software Assurance per year

**Key:** sa_pct

**Type:** number

**Default:** 25

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

**Help:** Annual SA as a percentage of licence cost, from your quote.

#### Years

**Key:** years

**Type:** number

**Default:** 5

**Min:** 1

**Max:** 10

**Step:** 1

**Outputs:**

#### Licensed cores, production

**Key:** prod_cores

**Expr:** prod_vms * max(4, prod_vcpu)

**Format:** integer

**Description:** Each VM counts its virtual cores with a minimum of 4.

#### Licensed cores, non-production

**Key:** np_cores

**Expr:** np_vms * max(4, np_vcpu)

**Format:** integer

#### 2-core packs

**Key:** packs

**Expr:** ceil((prod_cores + np_cores) / 2)

**Format:** integer

#### Licence cost

**Key:** licence_cost

**Expr:** packs * pack_price

**Format:** currency

#### Software Assurance per year

**Key:** sa_year

**Expr:** licence_cost * sa_pct / 100

**Format:** currency

#### Total cost over the period

**Key:** total_cost

**Expr:** licence_cost + sa_year * years

**Format:** currency

**Primary:** true

#### Cost per licensed core over the period

**Key:** cost_per_core

**Expr:** total_cost / (prod_cores + np_cores)

**Format:** currency

**Chart:**

#### Packs and total cost vs vCPUs per production VM

**Type:** line

**X:** prod_vcpu

**From:** 4

**To:** 32

**Steps:** 29

**Series:**

- packs
- total_cost

**Disclaimer:** Planning estimate only, not licensing advice. Licensing terms differ by SQL Server version, edition and agreement; confirm with Microsoft's licensing guide for your version and your reseller. No prices are assumed.

## Content

**Intro:** This calculator counts the SQL Server core licences a SyteLine 9 or 10 on-prem landscape needs when each database VM is licensed per core, then applies your quoted pack price and Software Assurance rate over a period. It answers how much SQL Server will cost for your SyteLine sizing without assuming any list price.

**Sections:**

#### How to use it

**Body:** Enter the number of production SQL Server VMs and their vCPUs, then any non-production VMs that need paid licences. Enter the price per 2-core pack from your quote for the edition you are buying, and the annual Software Assurance percentage. The outputs show licensed cores, packs, up-front licence cost, SA per year and the total over your chosen years. The chart sweeps vCPUs per production VM from 4 to 32, which is the conversation you have with your infrastructure team: every extra pair of vCPUs is another pack, so right-size the VM from measured CPU use before you buy.

**Bullets:**

- Use your reseller quote for the pack price
- Size vCPUs from real CPU history, not from the old physical box
- Re-run with Standard and Enterprise quotes to compare

#### The per-core rules the formula applies

**Body:** Under per-core licensing of individual virtual machines, you license every virtual core assigned to the VM, with a minimum of four core licences per VM, and core licences are sold in 2-core packs. So a 2 vCPU VM still needs 4 core licences, and an 8 vCPU VM needs 8, which is 4 packs. The calculator applies max(4, vCPUs) per VM, sums production and non-production, and rounds up to whole packs. Two points to check against Microsoft's guide for your version: newer versions tie per-VM licensing to active Software Assurance or subscription licences, and licensing all physical cores of a host with Enterprise and SA is a different model that allows unlimited VMs on that host.

**Bullets:**

#### What SyteLine puts on SQL Server

**Body:** SyteLine 10 on-prem runs its application, forms, objects and templates data in an all-in-one database, alongside any additional site databases in a multi-site setup. Reports run through SQL Server Reporting Services. If SSRS is installed on its own server, that server's operating system environment generally needs its own SQL Server licence, so add it as a production VM in the calculator when that is your design. Standard edition has hardware and feature limits that differ by version; compare them with your measured memory and core needs instead of assuming Standard is enough. A separate reporting replica for BI or AI workloads is another licensed production instance.

**Bullets:**

#### Worked example

**Body:** A site runs one production database VM with 8 vCPUs, a separate SSRS VM with 2 vCPUs, and dev and test on Developer edition. Enter production VMs 1 at 8 vCPUs. Because the second line simply applies the same per-VM rule, use it for the SSRS server: 1 VM at 2 vCPUs, which the 4-core minimum lifts to 4. That gives 8 + 4 = 12 cores, 6 packs. With a pack price P and 25 percent SA, licence cost is 6P, SA is 1.5P per year, and five years total 13.5P. Cutting the main VM to 6 vCPUs saves one pack and one quarter of a pack per year in SA.

**Bullets:**

**Cta:** If you are adding a private AI layer next to SyteLine, we can help size it so it reads from a replica you already license rather than adding new SQL Server cores.

**Faq:**

#### How much does SQL Server cost for SyteLine?

**Answer:** It depends on edition, cores and your agreement. Under per-core licensing the cost is the number of 2-core packs times the pack price, plus Software Assurance if you buy it. A single 8 vCPU production VM needs 4 packs. Enter your quoted price here for a multi-year total.

#### Is there a minimum number of core licences per VM?

**Answer:** Yes. When licensing individual virtual machines per core, each VM needs at least four core licences even if it has fewer vCPUs. That is why the calculator uses the larger of 4 and the vCPU count for every VM.

#### Do dev and test SyteLine databases need paid SQL Server licences?

**Answer:** Developer edition is free for development and testing that is not production use. Environments used for production workloads, such as a reporting copy that users rely on, need licensing. Check how your agreement treats test environments before entering zero.

#### Should I choose SQL Server Standard or Enterprise for SyteLine?

**Answer:** Many single-site installations run on Standard, but check its memory and core limits for your version against your measured workload, and whether you need Enterprise features such as readable secondaries for a reporting replica. Price both editions here with real quotes.

## Search terms

how much does sql server cost, microsoft sql server cost, sql server standard cost, cost of sql server, ms sql server cost, sql server core licensing calculator, syteline sql server licensing

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json