0

We are going to upgrade server with new hardware. And i'm kinda curious about how is SQL Server performance will improve. I'm not a DBA and know just a little about performance monitoring. My only idea is creating some heavy queries, run it before hardware replacement, run it after hardwaer replacement, compare execution time. Yeah i know that idea doen't even sounds good but it's all what i have.
Is there any way to benchmark performance in more common and efficient way?

Improve this question
1
  • 2
    enable query store
    – lear1
    Jun 19 at 12:22

2 Answers 2

Reset to default
0

Try to run a TPC-C benchmark with HammerDB

Improve this answer
0
0

HammerDB is the tool that you looking for, very easy to use, and you can make common tests or specific query tests with it. It is free and open source, you can download it from here. Very easy to install and you can find very proper documentation for usage here.

NOTE: Don't forget to start and setup agent.

If you are looking for something else too, I suggest the following article on this topic.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.