FPSINPUT.RECENT_REALTIME_BY_HOUR

>

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSADMIN.RECENT_REALTIME_BY_HOUR

Useful query to calculate the job metrics by hour including the average seconds per insert for recent WEH loads. This measures the performance of the RealTime in general and the WIP_EVENT_HIST triggers specifically. Because we use C on WIP_EVENT_HIST, this should work for both DB and APF ETL clients. Run this query and then copy to Excel and choose Charts -> Scatter -> Marked Scatter for the first five columns to generate a graph of recent refresh intervals for the critical data loads. You might want to extend the time longer than 2 days to query for the graph.