Saturday, March 15, 2008

Performance tuning (how to start?)

5 steps to tune a sick database.

1] Understand: the customer expectation and severity. (eg. expected time to complete a txn).

2] Identify: the area to be tuned, it can be memory or SQL or network or OS/hardware)

3] Analyze: the problem area, prepare a solution and think the aftermath effect.

4] Test: the solution if the problem occurs for the first time or go by experience.

5] Implement: the solution and repeat from step2 if needed.