| Subject | Detect user / database which causes high cpu-load |
|---|---|
| Author | philippe.requile |
| Post date | 2007-05-14T11:51:58Z |
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
(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