Test 1 Results

General Information

• Start Time: 10/22/2007 4:27:18 PM
• Users: 100
• Test Duration: 00:28:40

App server config

• maxThreads=250
• minSpareThreads=25
• maxSpareThreads=75

Database Notes

• Load Average: 0.29 to 97.50 which was recorded at 16:43:30
• Sar data for time in question(recorded on bricker)

  01:00:01 AM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15
  04:30:08 PM         6       410     24.00     10.52     19.94
  04:40:04 PM         7       503     92.64     71.63     46.95
  04:50:02 PM        25       503     84.55     88.60     68.69
  05:00:03 PM         0       519      1.45     34.77     54.18
  

Silk Data

Note: This table is the concatenation of two tables from silk performer.  Therefore blank columns only mean the column didn't exist in the original table.

Conclusions

We conclude that load test and system configuration simulated the poor performance we saw in production with the views.