Avatar of 25112
25112
 asked on

stress test workstation for SQL 2016 for CPU-specific evaluation

to do stress test to see CPU performance, (not memory or disk at this test)

what tool do you recommend for sql 2016 (other than native sqliosim)? preferably different CPU counters or advanced metrics calculations for CPU..

I see sqliosim is dated many years ago
https://support.microsoft.com/en-us/help/231619/how-to-use-the-sqliosim-utility-to-simulate-sql-server-activity-on-a-disk-subsystem
but does not have lot of counters for CPU performance nor does it seem like it specializes in CPU performance .. hence would appreciate expert suggestion for latest version..

and whatever CPU metric the report of the tool produces, it would be good to have a reference point of what is more relatively acceptable or good for the given stress test.
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon
Vitor Montalvão

For SQL Server, memory is a lot more important than CPU. Usually CPU usage will become more critic when the memory is full.
Anyway, you can always use the Windows Performance Monitor to get the CPU counter during the test phase.
25112

ASKER
Vitor I was thinking for sql workstation more than sql server.. does that make a difference of perspective?

also, can you I ask you: what CPU config have you found satisfactory for your local instance (workstation)? did you choose that cpu or was it just given to you?
ASKER CERTIFIED SOLUTION
Vitor Montalvão

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck