We use Classic on linux and can trace the pid back to the ip address
using ps and lsof. Not sure about Windows though.

-steve

philippe.requile wrote:

>
> The cpu utilization of our firebird server reaches 50% now and then
> (100% cpu utilization on 1 of the 2 processors).
>
> We have 10 FB databases on the server, and 100 users can connect one of
> these database files.
>
> Is there a way to find out
> - which database file causes the high load
> - which user/ipaddress started the cpu-consuming load
>
> Are there books/websites to solve this performance problem?
>
> Server= XP Pro SP2
> Firebird version: 2.0 - superserver
>
>