Hi

My problems with RAID 5 SCSI hw has solved by migrating the code for my
application from BDE to IBX. Daily opperation was to slow with BDE when I
had lot's of transaction with little records. All problems disapeard with
migrate the code from BDE to IBX.

Regards
Paul M

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of filip.moons
Sent: Monday, April 17, 2006 5:33 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Slow performance on Win2003 HW raid server

Hi,

One of our customers are experiencing extreme slow performance on
their p4 2.4ghz WIN2003 scsi HW raid system. I checked already the
most suggested causes but they didn't help anything. Shadow pages
disabled, no virus scanner present, fdb extension, hyper threading
disabled, cpy affinity... I even installed the classic version to
check if this would improve performance. It didn't. Even a simple
create db script runs extremely slow on their system. When i check
the processes tab from task manager on the server fbserver consumes
only 2% nothing during the create db script. When the same script is
run on a less performant computer taskmanager shows up 20% on
average and the script is done 4x faster then on the server. As a
test i put in a new IDE hd in and ran the script again. To my
surprise the create db script got executed very fast. Taskmanager
showed up an equal 20% processingtime by fbserver compared to the 2%
when done on their mirrored hw raid hds. Is this solely due to the
mirrored hds or can there be more to it. I really could use some
advice on this bc the customer doesn't accept its scsi HW raid
mirrored hds as a cause for the slow performance.

Greetings,
Filip Moons








++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links