Determine whether the problem is external or internal to
SAP Sybase IQ.
External to SAP Sybase IQ
- Monitor the OS, hardware, and storage for any bottlenecks or issues
- Look for high CPU use, high CPU system time, low CPU user time, high wait
time
- Look for I/O service times that are more than 10ms
Internal to SAP Sybase IQ
- Enable INDEX_ADVISOR and look for missing indexes
- Enable QUERY_PLAN_AS_HTML and the
INDEX_ADVISOR if the issue is with a single query