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 | 5.5 days IN PROGRESS (3 days 9 hours financial rollover, 2 days orders rollover WILL BE UPDATED) |
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
Memory Utilization
10K orders
50K orders
increase - mod-finance-storage
100K orders
DB CPU Utilization
10K orders
50K orders
100K orders
DB Connections
10K orders
50K orders
100K orders
Database load
10K orders
50K orders
100K orders
Top SQL
10K orders
50K orders
100K orders
