troubleshooting Question
stress test workstation for SQL 2016 for CPU-specific evaluation
25112 asked on
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.
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.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.