Investigating Missing Performance Data in NetApp OCI

I had to investigate why for some reason we were not getting performance data in NetApp OnCommand Insight for some EMC Symcli (Symmetrix/VMAX/PMAX) arrays. It turned out that performance collection had been disabled at the data source level.

The following DataWarehouse query shows you global datasources with additional message (tells you if collection is inventory only, or all - which is inventory and performance.)

## GLOBAL DATASOURCES: TYPE OF ACQUISITION AND HEALTH ##
SELECT au.siteName,ds.name,ds.type,ds.additionalDataSourceMessage
FROM dwh_inventory.acq_data_source AS ds
JOIN dwh_inventory.acq_acquisition_unit AS au ON au.id = ds.acquisitionUnitId
ORDER BY 1,3,4,2;

Then I needed to find out if it had ever worked, and - if it had - when did it stop working/get turned off. The following query helped me find this out. Unfortunately our available rest_access log data didn't go back far enough to find out what had disabled performance collection.

## AVERAGE DAILY IOPS PER STORAGE NODE PER STORAGE OVER ALL TIME FOR CURRENT STORAGE ARRAYS ##
SELECT sd.name,sd.manufacturer,sd.model,CEIL(AVG(COALESCE(p.totaliops,0))) AS 'AVG IOPs',MAX(d.fullDate)
from dwh_performance.storage_node_daily_performance_fact AS p
join dwh_performance.storage_dimension AS sd ON sd.tk = p.storagetk
join dwh_performance.date_dimension AS d ON d.tk = p.dateTk
join dwh_inventory.storage AS s ON s.name = sd.name
GROUP BY sd.name;