My suggestions would be to collect the uptodate statistics before you
start analyzing the problem. Then, enable statspack every 15min. during
business peak hours. Once you get the statspack report, review the top
5 timed waits and expensive queries from the statspack.
If you feel, only few queries causing the problem, tuning those queries
would sometimes salve the entire issue.
Before you start tuning, have a baseline, a target and then start
proceeding. tuning is not something you have done once and it works
forever, its a continous process.
Jaffar
Received on Mon Mar 27 2006 - 09:02:15 CST
