How to Test the Database
Post Date : 2022-11-12T18:31:01+07:00
Modified Date : 2022-11-12T18:31:01+07:00
Category: cheatsheet
Tags: database
Things you may concern when test your database
Basic
- CRUD
- Data mapping
Steps
- Setup environment
- Prepare data and testcases
- Run tests
- Report
Details
- Schema
- Database Table, Column
- Keys and Indexes
- Stored Procedures
- Trigger
- Database Server Configuration
- Functional
- Data integrity and consistency
Non functional testing
- Performance testing
- Load testing
- Stress testing
- Endurance testing
- Spike testing
- Volume testing
- Scalability testing
Common Performance Problems
- Long Load time
- Poor response time
- Poor scalability
- Bottlenecking
Common performance bottlenecks
- CPU utilization
- Memory utilization
- Network utilization
- Operating System limitations
- Disk usage