question

I believe this is a well-reputed benchmark software: https://www.hammerdb.com/

I have never used it myself, though.

There are several free benchmark scripts and published results.

However, only you can determine if they are appropriate for you situation. It may be your application is not CPU dependent, so adding more CPU will not affect the performance of your application at all. Maybe your application has lots of blocking. Memory may help that, but may not. You need to determine your bottlenecks in your specific situation and if you can live with them or need to fix them.

HI @AJ-AJ,

Thank you so much for posting here in Microsoft Q&A.

If you need to create SQL Server server performance benchmark query, you could refer below query:

 Set Statistics IO ON    
 go
 Set Statistics Profile ON
 go
 Set Statistics Time ON
 go

You could run SQL Profiler to trace the session which gives by session the CPU,READS,WRITES,DURATION which would provide limited server level information while the session is running on your workstation.

You could also refer below steps about Five Steps to Running a Successful Baseline / Benchmark Test.

• Step 1: Define Requirements & Specifications
  

• Step 2: Construct a Workload
  

• Step 3: Isolate and Document
  

• Step 4A – Run the Test
  

• Step 4B – Monitoring While the Baseline / Benchmark Test is Running
  

• Step 5 – Assess and Interpret

  
  

Best regards
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.