SQL Optimizacija – vpliv hardware profila na hitrost

Testirali smo kako vpliva Hardware profil strežnika 380 Gen9 na hitrost na SQL-u enega izmed CPU intenzivnih procesov:

Kratice:
HW Dynamic Power Saving mode = Balanced
ESX OS Balanced = Balanced
SQL/Terminal OS Balanced = Balanced
HW Statich High Performance Mode = HPM
ESX OS High Performance = HPM
SQL/Terminal OS High Performance = HPM

HW balanced, ESX balanced, SQL balanced, Terminal HPM
21 sec
HW balanced, ESX HPM, SQL balanced, Terminal HPM
22 Sec
HW balanced, ESX HPM, SQL HPM, Terminal balanced
21,7 Sec
HW balanced, ESX HPM, SQL HPM, Terminal HPM
21,4 Sec
HW HPM, ESX HPM, SQL HPM, Terminal HPM
18,71 Sec
HW HPM, ESX HPM, SQL balanced, Terminal HPM
19,5 Sec
HW HPM, ESX HPM, SQL HPM, Terminal HPM
20 Sec
HW HPM, ESX HPM, SQL HPM, Terminal balanced
19,4 Sec
HW HPM, ESX Balanced,  SQL HPM, Terminal HPM
19,7
HW balanced, ESX HPM,  SQL HPM, Terminal HPM
23,7

Zaključek je da načeloma ne vidimo razlike kaj se nastavi na OS nivoju ali virtualizacijskem nivoju ampak je relevanten HW nivo.

GregorO

Back to Top