Any one know about the performance tuning ..waht is the role for sqls in performance tuning stage..what kind of testing we have to do for the performance tuning..pls give some ideas
john [img]/images/graemlins/smile.gif[/img] <font color="blue"> </font>
DBAs administer, maintain, and tune databases.
SysAdmins administer, maintain, and tune the DB host.
Those two hopefully talk to each other.
DBAs and Developers optimize queries. Sometimes technical BAs do the same. It all varies by organization and staffing levels.
More ideally, some capacity planning was involved up-front and throughout the life-cycle process.
[ QUOTE ]
...what kind of testing we have to do for the performance tuning..pls give some ideas