Performance problems on new VPS server

[Dominique Bernaert]

Hello,

We have a Firebird running on our old Windows server (VPS) without problems serving several Unigui applications.

We are in the progress of migrating from the old server to a new Windows 2019 server (VPS) running in HyperServer 2019.

The new server has more memory (12 GB) and we use the same setup, but the performance is much worser than the old server.

I cannot figure out what could be the issue.

What I do see in the Windows task manager is that Firebird.exe appears in the wait chain (see screenshot).

We tried modifying the firebird configuration to classic and super classic without luck.

Does anybody have an idea about this?

The server is version 3.0.7.33374

Thank you for you help, desperately searching for a solution.

[Mathias Pannier (unitel)]

Hello,

Memory and CPU is not all. Check HDD (read/write Performance).

Can You describe in which case it is slower? 

See also https://ib-aid.com/en/simple-insert-update-delete-test-for-firebird/​ 

Regards

Mathias 

---

Von: firebird...@googlegroups.com <firebird...@googlegroups.com> im Auftrag von Dominique Bernaert <dberna...@gmail.com>
Gesendet: Mittwoch, 14. April 2021 20:38
An: firebird-support
Betreff: [firebird-support] Performance problems on new VPS server

 

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/fc6ef926-5ec9-4d23-9193-64938e8a7382n%40googlegroups.com.

ub.unitel GmbH, Schulstraße 16, 06792 Sandersdorf-Brehna
Geschaeftsfuehrung Klaus Richter, Olaf Meyer
Amtsgericht Stendal
HRB 26389 FA Bitterfeld Steuernr. 116/107/08597 Ust.identNr. DE815796778
Deutsche Bank IBAN DE53 86070024 0 6143234 00
Kreissparkasse Anhalt-Bitterfeld IBAN DE69 80053722 0 3050326 82
_____________________________________________________________________
Dieses E-Mail ist nur für den Empfänger bestimmt, an den es gerichtet
ist und kann vertrauliches bzw. unter das Berufsgeheimnis fallendes
Material enthalten. Jegliche darin enthaltene Ansicht oder Meinungs-
äußerung ist die des Autors und stellt nicht notwendigerweise die
Ansicht oder Meinung von ub.unitel GmbH dar.
Sind Sie nicht der Empfänger, so haben Sie diese E-Mail irrtümlich
erhalten und jegliche Verwendung, Veröffentlichung, Weiterleitung,
Abschrift oder jeglicher Druck dieser E-Mail ist strengstens untersagt.
_____________________________________________________________________

[Alexey Kovyazin]

Hello,

Measure the performance of your new server with simple insert update delete test

https://ib-aid.com/en/simple-insert-update-delete-test-for-firebird/

Regards, 

Alexey Kovyazin 

IBSurgeon 

чт, 15 апр. 2021 г., 15:47 Dominique Bernaert <dberna...@gmail.com>:

--

[Ros]

I am also looking for a way to optimise the performance of a server. I want to squeeze the best of it.

There is another tool that I recently discovered: IBExpert Benchmark

https://www.ibexpert.net/ibe/pmwiki.php?n=Main.Benchmark?from=Main.IBExpertBenchmarkTool

The tool gives me the following results:

Drive Test: 163%

CPU Test: 153%

Thread Test: 97%

Can you recommend some articles that work on how to optimise the performance of a server?

Will 64bit installation of Firebird increase the performance?  Will increasing the cache bring any risks?

Ros

[Alexey Kovyazin]

Hello Ros,

The Simple Insert/Update/Delete test is an open-source, clear, and very easy-to-understand method to measure the performance, with the table and graph of results from other systems, to compare and estimate results.

It requires only isql.exe to run.

It gives results in natural measurement units, like 120 seconds to insert 1000000 records per second, with XLS to calculate the material results inserts/second, updates/second, deletes/second.

If something is not clear, I can request the author of this test, the Firebird QA engineer, to clarify it. 

But if you run a proprietary closed-source test, with an artificial measurement unit in %% of something, I cannot help you, sorry.

If you are looking for general performance tuning, see the following

• Short Firebird database performance checklist (!)
• 23 More Ways To Speed Up Firebird (!)
• 45 Ways To Speed Up Firebird Database (!)
• Optimized Firebird configuration files (!)

from

https://ib-aid.com/en/articles/#performance

Regards,

Alexey Kovyazin

IBSurgeon

пт, 16 апр. 2021 г., 12:06 Ros <r...@mreji.info>:

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/df03b2d4-9329-4770-87b4-a19bf81ee705n%40googlegroups.com.