WP and CP's are at 100%

Document ID : KB000094192
Last Modified Date : 04/01/2019
Show Technical Document Details
Issue:
1 - High fragmentation on EH and EJPP
2 - Rebuilding the indexes on EH and EJPP does not resolve the issue 
3 - Query still reads version of the memory that is no longer needed 
4 - Missing indexes.
 
Cause:
Issues is with storage subsystem. Storage subsystem can create bottlenecks that drastically effect storage performance.
Resolution:
 Identify these issues early on by running benchmarks and analyzing your results. key metrics to monitor include: Queue depth, or the number of requests held in queue at one time; average disk queue length. Average I/O size in kilobytes. IOPS (reads and writes; random and sequential; average of overall IOPS) Throughput in megabytes per second. Write percentage vs. read percentage. Capacity (free, used and reserve).

======================================== ========================================================================


Workaround:The work around is to continually rebuild the indexes on EH and EJPP every 30 minutes