Database performance tunning

S

sengodan

New Member
Hi,

Iam planning to tune up my progress database of size more than 100G, I have already used the list of parameters below. Can anyone suggest if there is any other parameter which i left so that it can improve my database performance in production box ?

-B
-hash
-bibufs
-aibufs
-L
-Mn
-n
-Mm
-Ma
-Mi
-Mpb
-spin
-ServerType
-semsets
-directio
-aistall
-maxport
-basetable
-tablerangesise
-baseindex
-indexrangesize
 
Im not 100% up to speed on tuning at the moment (been a while since i did any DBA), however it would help to give some indication of the values you used. It also wouldnt harm to give an idea of number of tables, etc as well as obviously tuning a 100GB db with 1 table containing 1000 fields would be very different to tuning a 100GB db with 100 tables containing 15 fields each with indices stored on your fastest disks, etc.
 
Not to mention a description of the hardware and how you are configured on the hardware and some idea of user and transactions volumes and a description of the performance issues that you have ... merely anticipating a growth in the size of the database isn't in itself an indicator of needing tuning.
 
What they said.

In addition there are a number of options that are not parameters but rather configuration decisions like database blocksize, bi cluster size, storage area configuration, table and index assignments to storage areas and so on and so forth.

It's a big topic with a lot of complexity. Pardon me for tooting my own horn but you would be very well advised to get some professional help and mentoring. It's much faster and more effective than spending the next 5 years going back and forth in online forums ;)
 
Hi, mate.

The others were not offering you suggestions; they were asking you questions.

Tom is quite right (as usual ;)) - database tuning is a really big subject (big, big). You can spend years at it - and still there is more to learn.

However - if you give some more information then I am sure that a whole lot of suggestions will follow. You need to explain in detail exactly what hardware you have - and how its configured. You need to explain at least a bit about the database - how many tables - is it a package or developed in-house - how many users? - are they "busy" users? - do the users mainly enquire, update or input?

And you should not just list the DB parameters you've tinkered-with - but say what values you've assigned to them.

The bottom line is: the more information you provide - the better the suggestions will be.

Cheers,
Ron.
 
You must log in or register to reply here.
Back
Top