Hi,

we are running an ERP-System which is using Firebird v1.5.2.4731
Sometimes the ERP-system (and only the ERP-system) is so slow, that if
you want to jump to the next dataset, you'll have to wait >5 sec.
Sometimes an invoice is created and this takes about 10 - 20 sec.
I think here are a lot of triggers involved.
These problems are only sometimes a day and there is no pattern
identifiable at what time or action it occurs.

All over there are not many people using this ERP (max. 4)
Hardware: Windows SBS2003, Intel 3GHz, 2,5G RAM, 250 Gig, hardware raid 1.
When the ERP is slow, the network is running normal, no heavy aktivities
and the task manager of the SBS shows also everything clear.
I think the ERP-system is a delphi program, but I'm not 100% sure about
this.

Does firebird has an option like MySQLs log_slow_querys or something
similar?
Or is there another possibility to get to know what is going on in the db?

Database header page information:
Flags 0
Checksum 12345
Generation 27036806
Page size 4096
ODS version 10.1
Oldest transaction 27036789
Oldest active 27036790
Oldest snapshot 27036790
Next transaction 27036791
Bumped transaction 1
Sequence number 0
Next attachment ID 1
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Jan 18, 2007 18:11:29
Attributes force write

Variable header data:
Sweep interval: 20000
*END*


It would be glad if you could point me to the right direction for what
to search for or what to do.
At this point I've no idea how to find/solve the problem.

Thanks
Andi