10-04-2017, 08:35 PM
[attachment=5183]
SQL Tuner
SQL Tuner -
Problem Statement:
The normal scenario in today s industry is whenever a programmer or a developer writes a new query; they have to submit the query to the DBA of the company for tuning it. Even DBA was not able to tune the query to the fullest and even if it has been tuned it would take lots of time and resources of the DBA s. During the crunch time it is not possible to tune each and every query. The DBA s has to rely on his experience to do the tuning
As there are no set rules for tuning it. Sometimes even the experienced DBA was not able to tune the query.
Why SQL Tuner?
This topic was chosen to reduce the work of DBA s of tuning the query. This tool can be used even by the developer to tune the queries instead of going to the DBA for tuning it.
Project Scope:
This project is developed for tuning SQL Queries. Tuning can be done by reducing the total CPU time and also reducing the I/O taken by the Query.
Tuning is done in two ways: