14,500 questions
Hi,
What the size of tpm represents, and how these tests can conclude that SQL Server 2019 performance is lower than 2016 is unknown for me. The HAMMERDB is not Microsoft's software and cannot be commented on.
SQL Server 2019 performance never go back to that of SQL Server 2016 (PERFORMANCE DROP 10 %)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,346
Reputation points
I have two VM with same configuration , CPU/DISK/MEMORY and one Install SQL 2019 while another one install SQL2016
Using HAMMERDB to do the stress test , the tpm is 100K at SQL2016 while only 9xk at SQL 2019 ( no matter I change back to old CE, turn off all the database scope features, change to old compatibility mode....)
seems SQL 2019 just run SLOWER !!!
2016
2019
SQL Server | Other
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT 6,661 Reputation points2021-05-24T03:21:48.71+00:00 -
sakuraime 2,346 Reputation points
2021-05-24T06:15:16.817+00:00 okok. thanks
TPM , transaction per minutes.
so what's the tools from Microsoft to bench mark different version of SQL server ?
-
Cris Zhan-MSFT 6,661 Reputation points
2021-05-24T07:28:08.95+00:00 Hi, Sorry I did not find a benchmark test tool for SQL Server from Microsoft.
-
sakuraime 2,346 Reputation points
2021-05-25T02:37:36.787+00:00 okok thanks .
Sign in to comment -