What Is IOPS (I/O Operations Per Second)
What Is IOPS (I/O Operations Per Second)?
✍: FYIcenter.com
IOPS (I/O Operations Per Second) is a measurement on how fast a data
storage device can perform read and write operations. IOPS is not a throughput
measurement, it only gives you the total number of I/O operations. Throughput
can be estimated by multiplying IOPS with I/O block size, which is 8 KB in most
cases. For example, if a transaction executed 1000 IOPS and 8 KB per operation,
the throughput is 8,000 KB/sec or 8 MB/sec.
Strictly speaking, IOPS is a performance measurement of a data storage service, not a database service. However, since the performance of a database service heavily depends the underlying storage service, IOPS is also used as a performance measurement of a database service.
⇒ Table for IOPS Tests on INSERT Statements
⇐ IOPS Tests on Azure SQL Database with INSERT
2019-08-08, 1508🔥, 0💬
Related Topics:
