Identifying Memory Performance Issues (BUI)

Use the following procedure to identify and remedy memory hardware bottlenecks on Oracle ZFS Storage Appliance. Based on the results of the analytic dataset, suggested corrective actions are provided to increase memory performance by installing more DRAM.

1. Create a worksheet as described in Creating a Worksheet (BUI).
2. Click the add icon next to Add statistic.
3. Go to CACHE: ARC accesses: Broken down by hit/miss.
4. Wait at least 10 minutes.

   Note:

   Ten minutes is a general guideline. The amount of time may be adjusted if you have shorter-duration workloads that are memory intensive.
5. Examine the graph.

   You might want to install more DRAM when all of the conditions in the following table are present.

   Condition	Description
   ARC access hits for data or metadata are at least 75-97% compared to misses	The ARC is providing a benefit by storing data or metadata that the applications need.
   ARC access hits for data or metadata are significantly greater than prefetch hits	The majority of the ARC accesses are for real applications rather than just the prefetch mechanism.
   ARC is accessed at least 10,000 times per second	Oracle ZFS Storage Appliance is hitting DRAM, which is not the typical utilization of an idle system.
   Nearly all memory is consumed by the ARC, leaving very little unused memory	Oracle ZFS Storage Appliance is utilizing all of the DRAM possible for the ARC, not just serving a hot workload out of a small subset of the DRAM that is already present.