HP 3PAR System Reporter E-Media Kit, System Reporter Media Kit 10.4.9.1 Calculating Common Performance Metrics

System Reporter 2.8 3PAR System Reporter User’s Guide

10.4.9.1 Calculating Common Performance Metrics

Table 10-20shows 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	CASE WHEN d_rcount > 0 THEN d_rticks / (d_rcount * 1000.0)
(millisec)	ELSE 0 END
Write service time	CASE WHEN d_wcount > 0 THEN d_wticks / (d_wcount * 1000.0)
(millisec)	ELSE 0 END
Total service time	CASE WHEN (d_rcount + d_wcount) > 0 THEN (d_rticks +
(millisec)	d_wticks) / ((d_rcount + d_wcount) * 1000.0) ELSE 0 END
Read IO Size	CASE WHEN d_rcount > 0 THEN d_rbytes / (d_rcount * 1000.0)
(KBytes)	ELSE 0 END
Write IO Size	CASE WHEN d_wcount > 0 THEN d_wbytes / (d_wcount * 1000.0)
(KBytes)	ELSE 0 END

The Sample Data and Inventory Tables 10.35