Follow

Troubleshooting long query times for inspectors and reports

Product: Stratusphere FIT/UX

Product Version: ALL

Expires on: 365 days from publish date

Updated: Apr 16, 2015

 

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)

top-wait.png 

Possible Resolution(s):

1. SSH to the database VA (or HUB if the DB isn't a separate VA) and login as friend/sspassword then run: su -

(https://liquidwarelabs.zendesk.com/entries/24782618-How-do-I-Remote-Access-Stratusphere-Appliance-Console-)

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.

Also see: https://liquidwarelabs.zendesk.com/entries/23778236-How-do-you-resolve-slowness-on-the-Stratusphere-Hub-when-running-reports-and-navigating-the-UI-

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.