SQL Server 2022 - Core(s)/mimimum for around 120 users

Not sure if this belongs in this forum, but:

Consider a installation, planned for upgrade to V. 10 with about 120 users (on-premise).

Currently running on a 2017 SQL.

With it reaching EOL, customer is considering SQL 2022 (Standard)

Considering lisensing per core.

What are the mimimum/suggested # of cores that should be considered ?

regards

Eirik Simonsen

6 Jan 2025 | 12:16 AM

All Replies (1)

How many cores would greatly depend on the indivual core speed. No clear answer to give here.

My general advice would be for a setup of 120 users:

2 servers/vm's, one database, one web/app
Database server should have atleast 4 cores, 2,5 ghz (or greater), more importantly, make sure it has enough RAM, ideally enough to fit the whole database in RAM + some extra for Windows
Application server with 4 cores, 2,5 ghz (or greater), 8 GB ram or greater, make sure that you configure to use the batch task service, so that background operations are not done by IIS.
Seperate file server/drive for the SO ARC
Use the build-in performance report of SSMS to look for optimizations opportunities.

David Hollegien

10 Jan 2025 | 10:04 AM