|Subject||AW: [firebird-support] Delayed response after maschin reboot|
|Author||Klement Guenther - Munich-MR - external|
>It simple was a bad select statement missing an appropirate index.
> Any idea what's going on here?
> How to tell the server to be more verbose on it's activity
> eg. writing more information to the log file.
In this case Firebird tried to use the systems file cache which is empty after a boot of course which lead to some kind of disk trashing.
Try filemon at www.sysinternals.com for windows which shows disk aktivity in detail.
PS: I'm still looking for a tool monitoring on SQL level.