So I realized that HammerDB is itself a hammer and you can't run it locally as SQL Server will have no resources.  It's a client-server test so I put it...

• This reply was modified 7 months, 2 weeks ago by  MichaelT.

yes tempdb has been subject to significant changes. majority were done with 2016 - see https://learn.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sql-server-ver16%5B/quote%5D

Thanks, it's the only query where SQL 2017 beats our 2008 box...

I installed CU31 and it's slightly faster - we're down to 18 seconds vs 9 so twice as slow.  Tempdb is faster though - have there been huge improvements in...

Well, apparently I can't install CU31 as it's a lower version.

I downloaded it from

https://www.microsoft.com/en-us/download/details.aspx?id=56128

And when I tried to run it, it gave me the following message:

A SQL...

Yeah, I'll install CU31 and see.

I'll check the query store.

The logs for sqliosim did have some throttling in them.  Is it my impression but was the MDX faster for one...

Here are the 2017 logs

Here are the 2008 logs

Thank you for your excellent directions - I should have read it more closely:-)  I've run them on the 2017 box.  Should I run it on the 2008 box as...

I've created the ini files you provided.  I hit ok after loading the file and then start but nothing happens after the last entry

Created buffer pool. Size=18300 MB, buffers 2342400,...

one one of your other posts you mentioned that your VM's were Vmware - AWS and AZURE are a totally different kettle of fish and settings for those are...

see the other threads from the OP - using a...

Trying to get a sense of reasonable performance.

For instance, we just...

Yeah, that machine's results are all over the map with HammerDB and very low.  It ranges from 740-35,000 TPS.  50x difference...

But my other test results (not HammerDB) were metronomic in...

I installed HammerDB and I found a video of a VMWare machine with the same CPU processor (6130) - unbelievable luck.  The only difference is that the server has 8...

• This reply was modified 7 months, 4 weeks ago by  MichaelT.
• This reply was modified 7 months, 4 weeks ago by  MichaelT.
• This reply was modified 7 months, 4 weeks ago by  MichaelT.

I think it would be interesting to see performance differentials to know what is possible.   Also we may see performance differences between versions.  The script is simple.  If anything, I...