- Oracle ZFS Storage Appliance Analytics Guide, Release OS8.8.x
- Working with Analytics
- Identifying Memory Performance Issues (CLI)
Identifying Memory Performance Issues (CLI)
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.
- Create a worksheet as described in Creating a Worksheet (CLI), select that worksheet, and then enter
dataset
.hostname:analytics worksheets> select worksheet-000 hostname:analytics worksheet-000> dataset
- Enter
set name=arc.accesses[hit/miss]
, and then entercommit
to add cache ARC accesses broken down by hit/miss to your worksheet.hostname:analytics worksheet-000 dataset (uncommitted)> set name=arc.accesses[hit/miss] name = arc.accesses[hit/miss] hostname:analytics worksheet-000 dataset (uncommitted)> commit
- Enter
done
, and then enterdone
again to exit the context.hostname:analytics worksheet-000> done hostname:analytics worksheets> done
- Wait at least 10 minutes, and then go to
analytics datasets
.Note:
Ten minutes is a general guideline. The amount of time may be adjusted if you have shorter-duration workloads that are memory intensive.hostname:> analytics datasets
- Enter
show
to view a list of available datasets.hostname:analytics datasets> show Datasets: DATASET STATE INCORE ONDISK NAME dataset-000 active 1.27M 15.5M arc.accesses[hit/miss] dataset-001 active 517K 9.21M arc.accesses[hit/miss=metadata hits][L2ARC eligibility] ... hostname:analytics datasets>
- Enter
select
and the dataset with the namearc.accesses[hit/miss]
.In this example, dataset name
arc.accesses[hit/miss]
corresponds todataset-000
.hostname:analytics datasets> select dataset-000
- Enter
read 600
to read the last 600 seconds, or 10 minutes, of the dataset.hostname:analytics dataset-000> read 600
-
Examine the data.
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.