> Too many deadlock scans, it means long (> 10 sec) waiting for some locks. > Regular (every few minutes) fb_lock_print -w output could probably shed > some light...
Here are some initial results
C:\FIREBIRD\bin>fb_lock_print.exe -d xxxxxxxxx -iw 1 5000
01:08:29 wait/s reject/s timeout/s blckast/s wakeup/s dlkscan/s
deadlck/s
01:08:30 0 0 0 0 0 0
0
01:08:31 0 0 0 0 0 0
0
01:08:32 0 0 0 0 0 0
0
01:08:33 0 0 0 0 0 0
0
01:08:34 65 5 0 66 66 0
0
01:08:35 108 25 0 108 108 0
0
01:08:36 0 0 0 0 0 0
0
01:08:37 0 0 0 0 0 0
0
01:08:38 58 2 0 58 58 0
0
01:08:39 71 20 0 71 71 0
0
01:08:40 0 0 0 0 0 0
0
01:08:41 0 0 0 0 0 0
0
01:08:42 0 0 0 0 0 0
0
01:08:43 0 0 0 0 0 0
0
01:08:44 25 3 0 21 25 0
0
01:08:45 24 8 0 23 24 0
0
01:08:46 0 0 0 0 0 0
0
Sean
