![[layout image]](images/round-185-top.gif){kind=small}
![[layout image]](images/round-185-bot.gif){kind=small}
Performance Tuning
Server performance analysis from database servers through to
the deployment layer
Desipite falling hardware prices it is still worthwhile carrying out a structured performance tuning exercise, especially when the user community may be experiencing degradation in system performance. Throwing additional hardware at a problem does not always solve it. Modern systems that utilise Internet Protocol are becoming increasingly complex.
A defined approach to investigating the entire technical stack is required. Tuning should start at the design phase as this is where the biggest gains can be made. Sadly it is often too late to change the design of a production system but by tuning the SQL and code, good gains can be made.
To a lesser extent database and server tuning can also yield very beneficial results. DSP is closely associated with CopperEye developers of revolutionary adaptive addressing indexing for Oracle that in most cases it will have a significant impact on index performance.
Server performance analysis from database server through to the deployment layer (in many
cases a browser)
the deployment layer
Desipite falling hardware prices it is still worthwhile carrying out a structured performance tuning exercise, especially when the user community may be experiencing degradation in system performance. Throwing additional hardware at a problem does not always solve it. Modern systems that utilise Internet Protocol are becoming increasingly complex.
A defined approach to investigating the entire technical stack is required. Tuning should start at the design phase as this is where the biggest gains can be made. Sadly it is often too late to change the design of a production system but by tuning the SQL and code, good gains can be made.
To a lesser extent database and server tuning can also yield very beneficial results. DSP is closely associated with CopperEye developers of revolutionary adaptive addressing indexing for Oracle that in most cases it will have a significant impact on index performance.
Server performance analysis from database server through to the deployment layer (in many
cases a browser)
- Database tuning
- SQL, PL/SQL, forms, reports, C tuning
- Unix/NT tuning
- Analysis and implementation of CopperEYE
- Adaptive addressing
![[layout image]](images/round-870-top.gif){kind=small}
![[layout image]](images/round-870-bot.gif){kind=small}