Subject | how to reduce cpu usage? |
---|---|
Author | Ernesto Benestante |
Post date | 2003-11-12T10:04:31Z |
Is there any way to limit the cpu usage of the FB server? I don't care if
the queries take longer to finish...
I have some dedicated servers with mixed processes: someones are database
bound, others are hardware bound. While I don't matter to much if the
queries take longer, I cannot allow that the hardware related processes skip
any probes. The problem is that during certain queries the FB server takes
all the cpu cycles for itself and the rest of the processes starve...
Also, I can't: (a) put each process in different computers due to cost
problems, (b) rewrite the offending queries/algorithms to be more
lightweight on the database bound processes (they aren't under my control,
and it seems to be "impossible").
I tried to change the priority of the FB server process with the Task
Manager, but I get an "access denied" error.
Thanks in advance
Ernesto Benestante
the queries take longer to finish...
I have some dedicated servers with mixed processes: someones are database
bound, others are hardware bound. While I don't matter to much if the
queries take longer, I cannot allow that the hardware related processes skip
any probes. The problem is that during certain queries the FB server takes
all the cpu cycles for itself and the rest of the processes starve...
Also, I can't: (a) put each process in different computers due to cost
problems, (b) rewrite the offending queries/algorithms to be more
lightweight on the database bound processes (they aren't under my control,
and it seems to be "impossible").
I tried to change the priority of the FB server process with the Task
Manager, but I get an "access denied" error.
Thanks in advance
Ernesto Benestante