AWR可以估算出磁盘的IOPS,MBPS性能指标吗?
请教各位，AWR可以估算出磁盘的IOPS,MBPS性能指标吗?如果AWR不能估算，是否有其他方法可以对现行生产库进行抽样测试后推算出来呢? FYI
参考AWR中的Instance Activity Statistics 环节
IOPS = “physical reads total I/O requests” + “physical writes total I/Orequests”
MBytes/s = “physical reads total bytes” + physical writes total bytes”
physical read total IO requests 3,272,436 455.48 34.52
physical write IO requests 314,647 43.79 3.32
IOPS = “physical reads total I/O requests” + “physical writes total I/Orequests” = 455+43 = 498
physical read total bytes 3,218,786,182,144 448,007,955.58 33,956,306.25
physical write total bytes 72,372,139,008 10,073,143.17 763,483.62
MBytes/s= 448,007,955 + 10,073,143 ＝ 458081098bytes= 436 MB/s
大致计算其 IOPS 为 498 而 吞吐量为 436MB/s
http://t.askmaclean.com/thread-2041-1-1.html
页:
[1]