Elements and Performance Criteria
- Diagnose problems
- Determine appropriate database performance diagnostic tool to use based on organisational database requirements and vendor recommendations
- Run diagnostic tool to identify issues causing degradation of database performance
- Determine and record where inappropriate use of database and temporary table spaces occur
- Carry out appropriate fixes based on diagnostic results
- Configure database
- Tune database
- Track the module performance according to specifications
- Monitor and tune the efficiency of structured query language (SQL), as required
- Monitor and measure the performance of shared pool, blocks and buffers
- Detect, identify and resolve contentions that may arise in the real-time operation of the database
- Reconfigure the database according to specifications