Subject RE: [***SPAM*** Score/Req: 5.4/4.0] Re: [firebird-support] FB CPU Usage
Author Andrew Stuart

Page size : 4096

As far as im away the indexes are setup as best as possible, previous
staff looked after it.

Not sure how I found out 'number of cache pages'

[] On Behalf Of Aage Johansen
Sent: 09 July 2008 13:34
Subject: [***SPAM*** Score/Req: 5.4/4.0] Re: [firebird-support] FB CPU

call.assist wrote:
> Hi All
> We're currently running FB 1.5 on a Win2k3 Server
> Decent spec, twin 3ghz xeons, 3ghz memory and scsi raided hdd's
> We are experincing a fairly high cpu usage, which spikes from around
> to 40% every few seconds roughly.
> We havent changed alot in terms of usage (currently around 100 users
> thru a custom piece of software )
> Is this normal on other peoples setups, or is there something-a-foot

Are you using SuperServer or Classic?
What is the page size and "number of cache pages"?
Are there (sensible) indexes available?
Plus any other info you may think valuable will make it easier for
someone to help.

Aage J.

Head and Registered Office:
Call Assist Ltd,
Axis Court, North Station Road,
Colchester, Essex.
Telephone +44 (0)1206 771771
Fax +44 (0)1206 364268

Registered in England and Wales.
Registered Company Number 3668383
Authorised and regulated by the Financial Services Authority

Please Note : This electronic message contains information from Call Assist Ltd which may be privileged or confidential.
The information is intended for the use of the individual(s) named above. If you are not the intended recipient be aware
that any disclosure, copying, distribution or use of the contents of this information is prohibited.
If you are not the intended recipient please delete this email. If you have received this electronic
message in error, please notify us by telephone or email immediately.

Please consider the environment before printing this email.

[Non-text portions of this message have been removed]