We help IT Professionals succeed at work.

stress test workstation for SQL 2016 for CPU-specific evaluation

25112
25112 asked
on
286 Views
Last Modified: 2017-03-09
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.
Comment
Watch Question

Vitor MontalvãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.

Author

Commented:
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?
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions