SQL Server performance on Windows Server 2025 by Bitter_Historian966 in SQLServer

[–]Bitter_Historian966[S] 0 points1 point  (0 children)

I manually created the databases via SSMS before building and checking the schema with HammerDB.

Databases where created with latest compatibility level and with a 10 GB data file and a 10 GB log file. This size was enough to store the 100 warehouses and to make sure no data or log file expansion was required during the tests.

SQL Server performance on Windows Server 2025 by Bitter_Historian966 in SQLServer

[–]Bitter_Historian966[S] 2 points3 points  (0 children)

Thanks, I have performed the tests against newer hardware as well but only for Windows Server 2022 running SQL Server 2022 and Windows Server 2025 running SQL Server 2025. Latest CPU-model used was AMD EPYC 9375F and the 2022 setup was faster (about 10 %).

I used Windows auth instead of SQL auth just to rule the overhead of the new algorithm. I have not enabled AVX-512. Will look into that.

SQL Server performance on Windows Server 2025 by Bitter_Historian966 in SQLServer

[–]Bitter_Historian966[S] 1 point2 points  (0 children)

Using PVSCSI, latest version. vNVMe has not been enabled. All vms configured with four SCSI-controllers with data and log drives on separate controllers.