Overview
This document contains the results of testing Fiscal year rollover in scope of ticket PERF-289 - Getting issue details... STATUS .
Summary
TBD
Test Runs and results
Test # | Scenario | Load level | Data quantity | Fiscal year rollover duration | Comments |
|---|---|---|---|---|---|
| 1. | Fiscal year rollover | 1 rollover at a time | 10K orders: 5K - open 5K - closed | 3 hours (2 hours financial rollover, 1 hour orders rollover) | No errors |
| 2. | 50K orders: 40K - open 10K - closed | 2 days 6 hours (1 day 8 hours financial rollover, 22 hours orders rollover) | No errors | ||
| 3. | 100K orders: 90K - open 10K - closed | 8 days (6 days 6 hours financial rollover, 1 day 18 hours orders rollover) | Rollover was stoped manually, "Out of shared memory" error occurred. | ||
| 4. | 100K orders: 50K - open 50K - closed | 6 days 13 hours (3 days 9 hours financial rollover, 3 days 4 hours orders rollover) | Rollover finished by itself, "504 Gateway Time-out" error occurred. |
Service CPU Utilization
10K orders
mod-orders-storage is about 40-60% during orders rollover stage
50K orders
spike - mod-finance-storage
mod-orders-storage is about 15-20% during orders rollover stage 
100K orders (90K - open, 10K - closed)
100K orders (50K - open, 50K - closed)
Memory Utilization
10K orders
50K orders
increase - mod-finance-storage
100K orders (90K - open, 10K - closed)
100K orders (50K - open, 50K - closed)
DB CPU Utilization
10K orders
50K orders
100K orders (90K - open, 10K - closed)
100K orders (50K - open, 50K - closed)
DB Connections
10K orders
50K orders
100K orders
100K orders (50K - open, 50K - closed)
Database load
10K orders
50K orders
100K orders (90K - open, 10K - closed)
100K orders (50K - open, 50K - closed)
Top SQL
10K orders
50K orders
100K orders (90K - open, 10K - closed)
100K orders (50K - open, 50K - closed)
