HP 3PAR System Reporter Software - Manual (Page 327)

10.35 The Sample Data and Inventory Tables
System Reporter 2.8 3PAR System Reporter User’s Guide
10.4.9.1 Calculating Common Performance Metrics
Table 10-20 shows SQL expressions that can be used to calculate various performance metrics
from the common performance columns for any sample row.
Table 10-20. Common Performance Metrics for a Sample Row
Metric SQL Expression
Read IOPs/s CASE WHEN d_now > 0 THEN d_rcount * 1000000.0/d_now ELSE 0
END
Write IOPs/s CASE WHEN d_now > 0 THEN d_wcount * 1000000.0/d_now ELSE 0
END
Total IOPs/s CASE WHEN d_now > 0 THEN (d_rcount + d_wcount) *
1000000.0/d_now ELSE 0 END
Read KBytes/sec CASE WHEN d_now > 0 THEN d_rbytes * 1000.0/d_now ELSE 0
END
Write KBytes/sec CASE WHEN d_now > 0 THEN d_wbytes * 1000.0/d_now ELSE 0
END
Total KBytes/sec CASE WHEN d_now > 0 THEN (d_rbytes + d_wbytes)* 1000.0/
d_now ELSE 0 END
Read service time
(millisec)
CASE WHEN d_rcount > 0 THEN d_rticks / (d_rcount * 1000.0)
ELSE 0 END
Write service time
(millisec)
CASE WHEN d_wcount > 0 THEN d_wticks / (d_wcount * 1000.0)
ELSE 0 END
Total service time
(millisec)
CASE WHEN (d_rcount + d_wcount) > 0 THEN (d_rticks +
d_wticks) / ((d_rcount + d_wcount) * 1000.0) ELSE 0 END
Read IO Size
(KBytes)
CASE WHEN d_rcount > 0 THEN d_rbytes / (d_rcount * 1000.0)
ELSE 0 END
Write IO Size
(KBytes)
CASE WHEN d_wcount > 0 THEN d_wbytes / (d_wcount * 1000.0)
ELSE 0 END