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:hstreic...@gmx.de
