Problem:
Inspectors and reports take a long time to load.
Symptoms:
CPU I/O wait is high on the database appliance: (example only to show the field, this system has next to no I/O wait)
Possible Resolution(s):
1. SSH to the database VA (How do I Remotely Access Stratusphere Appliance Console?) (or HUB if the DB isn't a separate VA) and login as friend/sspassword then run:
sudo bash
2. Execute the following command and look at the 'wa' value highlighted above: top
3. Run a report or load an inspector that you haven't recently looked at (so we know the data isn't coming from cache) and watch the 'wa' value in 'top'.
This value is the % of CPU time spent waiting on disk I/O. The higher the number, the longer the database is waiting for I/O and the slower the reports and inspectors will be. Anything under 10% isn't too bad but ideally this would be as low as possible. If the value is too high, consider migrating the DB appliance to faster or less utilized storage and repeat the process to confirm the value does not climb as high on the new underlying storage.
Product: Stratusphere FIT/UX
Product Version: ALL
Expires on: 365 days from publish date
Updated: Apr 16, 2015