Performance & Tuning

In Performance & Tuning, structured approach/ techniques are applied to investigate performance problems. The objectives are:

  1. To evaluate the Architecture of the system
  2. To evaluate the performance of the system
  3. To evaluate the Database Design
  4. To rewrite SQL taking into account the database optimizer
  5. To tune various global RDBMS server parameters

Previous Work

In the past the company and its officer(s) had been involved with the following Performance & Tuning:

  1. Tuned a major Fund Management application PERTH from approximately 8 hours to 3 hours by redesign of indexes, stored procedures (SQL), and database schema and server reconfiguration.
  2. Tuned performance for the Emission Data Systems significantly [by a factor of 20]. When the performance issue was fixed; the job took 7-8 hours instead of 150+hours. I was able to achieve this by developing parallelism in the tasks to be done.
  3. Have monitored and fixed timeouts through database performance and tuning.

Follow us on: Facebook, Google