Subject | AW: [firebird-support] Delayed response after maschin reboot |
---|---|
Author | Klement Guenther - Munich-MR - external |
Post date | 2003-12-19T07:53:16Z |
>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.
Regards
PS: I'm still looking for a tool monitoring on SQL level.