Etl performance testing

                                                                                                                                         <<<            >>>

ETL Performance Tuning:

In the Phase of ETL Performing testing , A tester can involve in database Level or Core Database Level. As well as database tester and the same time ETL tester can involve in Performance tuning also. Performance tuning means server side based work.

What is a Performance Testing :

To test the Server response with different user loads. The Purpose of performance testing is to find bottle neck in the application.

What is a Bottle Neck ?

Bottle Neck is a break point where the server will be in peak (or) the bottle neck is a pin point (or) break point when the server responds where the server will be busy with the user request.

ETL Performing Life cycle :

•       Work flow requirements

•       Performing Objective

•       Performing testing

•       Performing Measurements

•       Performance Tuning

•   ETL Workflow requirements:-

In the Phase of work flow req, ETL Tester can identify the performing scenarios how to connect the database to server which environment supports the performance testing and to check the front end and back end environment and batch jobs, data merging, file system components finally reporting events.

•   Performing Objective :

The performing objective is to start end to end performance testing most

Of the time performing objective will be decided by the client.

•   Performing Testing :

To calculate the speed of the project , ETL Tester can test the DataBase Level . The data base is loading the target properly or not. When ETL Developer doesn’t loads the data in proper conditions then some damage is caused in the performance of the system.

•   Performing Measurements :

At the time of Performing execution, we need to measure the below metrics.

    Client side metrics 2.hits/sec 3. Through put 4. Memory allocation,5. Process resources 6. Database statistics database user conditions.

•   Performance Tuning :

It is a mechanism to get a fixed performance related issues as a Performance tester , we are going to give some suggest recommendations to tuning department.

Code Level ---------- Developer

Data Base Level-----------DBA

Network Level------------Administrator

System Level-------------S/A

Server Level------------Server side People.