Thank you for the tutorial! Are you using VMWare or Hyper-V? We have the same CPU Xeon 6130 running VMware and get 750-100,000 TPMs with 4 CPUs assigned to SQL Server 2017. It's usually under 10,000 TPMs which is frustrating. I ran the test the exact same way you did. Do you use Direct IO?

@jimv1210vasquezjames

Ай бұрын

I'm using Hyper-V. The test didn't use Direct IO.

@techsamurai11

Ай бұрын

​@@jimv1210vasquezjames Wow, you're getting so much better performance than we do with 4 vCPUs with SQL 2017 and SQL 2008 R2. Can it just be the hypervisor?

@jimv1210vasquezjames

Ай бұрын

@@techsamurai11 Maybe. Additionally, the server has NVMe PCIe disks

hola como hacer prueba de VOLUMEN en HammerDB

I did some test using hammerdb on postgresql and mssql, when running db schema creation, mssql got 50,000 TPM while postgresql got 8,000 TPM. But the postgresql finish within 2 minutes while mssql 12 minutes. How come? I use the same settings, 8 warehouses and 5 virtual users. But when running driver script , postgresql was faster than mssql, 50000-68000 vs 42000-52000 TPM

@user-lj4lo7cx7m

9 ай бұрын

Were you able to find why it took less?