How to make Firebird work 20% faster on Windows Server 2016 in less than 1 minute by IBSurgeon
More and more users upgrade to Windows Server 2016 from old versions, and some of them have noticed that Windows Server 2016 works slower than previous versions, even on the same hardware with the same database.
We have made several tests on Windows Server 2016 and Firebird, and found, among other things, the option, which dramatically influences the performance of the Windows Server 2016: the power plan.
By default, Windows 2016 has «Balanced» power plan, which automatically balances performance with energy consumption on capable hardware. Well, sounds not dangerous, but in fact, Balanced power plan at Windows Server 2016 greatly suppresses CPU performance and decrease the overall performance of the server.
It is possible to switch Power plan on the fly, no need to reboot. See the effect of enabling «High Performance» power plan on the server with Firebird database, which serves 70 connections:
more info:
Для просмотра ссылки Войди или Зарегистрируйся