NTISthis.com

Evidence Guide: ICTDBS404 - Identify and resolve common database performance problems

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTDBS404 - Identify and resolve common database performance problems

What evidence can you provide to prove your understanding of each of the following citeria?

Diagnose problems

  1. Determine an appropriate database performance diagnostic tool to use, based on organisational database requirements, and vendor recommendations
  2. Run a diagnostic tool to identify the issues causing degradation of the database’s performance
  3. Determine and record where the inappropriate use/s of database and temporary table spaces occur
  4. Carry out appropriate fixes, based on diagnostic results
Determine an appropriate database performance diagnostic tool to use, based on organisational database requirements, and vendor recommendations

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Run a diagnostic tool to identify the issues causing degradation of the database’s performance

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine and record where the inappropriate use/s of database and temporary table spaces occur

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Carry out appropriate fixes, based on diagnostic results

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Configure the database

  1. Adopt a distributed files architecture to minimise input and output (I/O) contention
  2. Ensure that database backup procedures are appropriate for the method of data storage
  3. Reconfigure rollback segments
  4. Configure the database and test its performance
Adopt a distributed files architecture to minimise input and output (I/O) contention

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Ensure that database backup procedures are appropriate for the method of data storage

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Reconfigure rollback segments

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Configure the database and test its performance

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Tune the database

  1. Track module performance according to its specifications
  2. Monitor and tune the efficiency of structured query language (SQL), as required
  3. Monitor and measure the performance of shared pool, blocks and buffers
  4. Detect, identify and resolve any contentions that may arise in the real-time operation of the database
  5. Reconfigure the database according to specifications
Track module performance according to its specifications

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Monitor and tune the efficiency of structured query language (SQL), as required

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Monitor and measure the performance of shared pool, blocks and buffers

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Detect, identify and resolve any contentions that may arise in the real-time operation of the database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Reconfigure the database according to specifications

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Diagnose problems

1.1 Determine an appropriate database performance diagnostic tool to use, based on organisational database requirements, and vendor recommendations

1.2 Run a diagnostic tool to identify the issues causing degradation of the database’s performance

1.3 Determine and record where the inappropriate use/s of database and temporary table spaces occur

1.4 Carry out appropriate fixes, based on diagnostic results

2. Configure the database

2.1 Adopt a distributed files architecture to minimise input and output (I/O) contention

2.2 Ensure that database backup procedures are appropriate for the method of data storage

2.3 Reconfigure rollback segments

2.4 Configure the database and test its performance

3. Tune the database

3.1 Track module performance according to its specifications

3.2 Monitor and tune the efficiency of structured query language (SQL), as required

3.3 Monitor and measure the performance of shared pool, blocks and buffers

3.4 Detect, identify and resolve any contentions that may arise in the real-time operation of the database

3.5 Reconfigure the database according to specifications

Required Skills and Knowledge

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Diagnose problems

1.1 Determine an appropriate database performance diagnostic tool to use, based on organisational database requirements, and vendor recommendations

1.2 Run a diagnostic tool to identify the issues causing degradation of the database’s performance

1.3 Determine and record where the inappropriate use/s of database and temporary table spaces occur

1.4 Carry out appropriate fixes, based on diagnostic results

2. Configure the database

2.1 Adopt a distributed files architecture to minimise input and output (I/O) contention

2.2 Ensure that database backup procedures are appropriate for the method of data storage

2.3 Reconfigure rollback segments

2.4 Configure the database and test its performance

3. Tune the database

3.1 Track module performance according to its specifications

3.2 Monitor and tune the efficiency of structured query language (SQL), as required

3.3 Monitor and measure the performance of shared pool, blocks and buffers

3.4 Detect, identify and resolve any contentions that may arise in the real-time operation of the database

3.5 Reconfigure the database according to specifications

Evidence of the ability to:

correctly identify common database problems

select appropriate solutions to solve the problem

implement solutions to improve database performance.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

outline the principles of database design and structured query language (SQL)

describe the principles of database administration

describe diagnostic tools and database tuning methodologies.