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?

1
  • 2
    enable query store
    – lear1
    Commented Jun 19, 2023 at 12:22

2 Answers 2

0

Try to run a TPC-C benchmark with HammerDB

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.

Your Answer

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

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