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.
Anyway, you can always use the Windows Performance Monitor to get the CPU counter during the test phase.