Performance Tuning a Database 2

[pivan]

Hi:

Can anyone provide a strategy as to how to tune a database and optimize it for performance. What should we be looking at? ANd how often.

Thanks,
pivan In not now, when?
If not here, where?
If not us, who?

Just do it!!

 

[mbryant]

Tuning the database depends on many factors and can differ based on the database engine being used however one important point remains the same, the design, if a database is badly designed then you may as well forget about optimisation and tuning.

Check out

http://WWW.SQL-Server-Performance.com

Matt

 

[dbmsguy]

your question is very general....

step 1. tune your dbms as best you can to the environment that it is operating in. this is the first step you must always do... ex ... memory. one always true axiom is 'the best I/O is the one you never do'. so think about caching. usually, memory is better than cpu so make sure you allocate enough memory to your server.

db physical design...

know your application. consider physically separating highly active tables on different disk areas to avoid io contention. use as many of your dbms's options as possible to optimize physical layout.

think through your index selections carefully. especially clustering index. don't put on too many indexes as the more indexes you have the longer your inserts take.

know how many rows you expect for ever table and size db properly.

just a few thoughts Paul

http://www.dbmsguy.com