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 | No errors |
| 2. | 50K orders: 40K - open 10K - closed | 2 days 6 hours | No errors | ||
| 3. | 100K orders: 90K - open 10K - closed | 8 days | "Out of shared memory" error |
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
