Subject Re: Slow performance on Win2003 HW raid server
Author Ali Gökçen
Hi,
there is alot of disk tools to discover DISK I/O performance, like
sisoft etc.. (do compare different DISC/interface types on that
machine)

You should check your platform regardless of FB performance.
FB unawered about RAID or media type, it uses only WINOS I/O API.


Regards.

Ali

--- In firebird-support@yahoogroups.com, "filip.moons"
<filip.moons@...> wrote:
>
> 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
>