Guten Tag Alexey Kovyazin,

nice Questionaire , i would suggest to add 1 more point
if it has a Raid then the size of the Stripe Set



The Stripe Set ist the amount of data a raid moves to / from the diskarray for every read/write.

Example:
a Raid 5 with 3 Disks and a Stripset of 128 KB means that each Read / Write will move 192 KB
now add a Database Page Size of 4 KB (Worst Case)
then every database page read or written will instead move 192 Kb or a 48 fold overhead

> Hi All,

> I am a bit tired of repeated topics regarding database performance, so I
> decided to publish short version of our performance questionnaire:
> http://ib-aid.com/articles/item157

> I suggest to always ask people who come here with Firebird performance
> problems to answer these questions and send answers to the list, in
> order to facilitate performance problems resolution.

> Regards,
> Alexey Kovyazin
> IBSurgeon






> ------------------------------------

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> Visit http://www.firebirdsql.org 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

--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...