QAD BI v3 - Tech Level 2 Certification - Part 4 > Troubleshooting Performance > Common Performance Issues
  PPT
Common Performance Issues
Common Performance Issues
 
This query checks the scheduler and returns the slowest running tasks that it finds. Change the number of days from 3 to a bigger number if there have been no daily runs for a while. The results of the query provides a list of our biggest bottlenecks in run times for us to focus on.
Common Performance Issues
 
The results of this query gives us a quick view at what all the process days and lookback parameters are set to for each module that is installed. If there are any really large numbers that are not appropriate, we’d quickly see them in these results (instead of looking through the parameter list).
Common Performance Issues
 
This query reveals which fact, dim and perm tables contain the most rows. If we’re seeing extreme slowness on some of these tables, the reason may be that we have more years worth of data than the users need, or it may just be appropriate. Either way, if we’re seeing slow jobs tied to tables with 50 million rows, we then already have an idea of why that task may be running slow.