What are the possible reason for a SP that normally runs in approx 20 seconds then Occasionally takes 15 minutes, (or a method of trying to find the cause of the problem).

Firebird Details

Server Version: WI-V2.5.5.26952 Firebird 2.5 32 bit Superserver, CpuAffinityMask = 1 in firebird.conf

System

Windows 10 Pro 64 bit

Processor Intel Xeon CPU E5530 @ 2,4 GHz Quad CPU

Memory 12.0 GB

Accessing DB using IBObjects components (TIBStoredProc)

Available tools IBExpert

Thanks for any help

Jack