Bert et al, server optimization questions:

You running SQL express or Standard? How many simultaneous users?

Express can only use 1-2Gb cache RAM, 1 cpu max 4 cores + minimal parallelism.

SQL express limits

Given the limits, guessing that SQL express would prefer faster clock speed over higher core count and fast queue depth 1 SSD database access to compensate for limited memory cache. I'm trying out an Optane 905p which has fastest random queue depth 1 speeds (should be ideal for SQL)

For start up and erx start time (which sends a lot of info) maybe 2.5Gb networking will help? Or are we limited by AC server software?

Anyone test for which components make the biggest difference in AC performance?

Larry
Solo IM
Midwest