...
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 6 days 13 hours IN PROGRESS (3 days 9 hours financial rollover, 2 3 days 4 hours orders rollover WILL BE UPDATED) | Rollover finished by itself, "504 Gateway Time-out" error occurred. |
Service CPU Utilization
10K orders
...
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
...
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)
