What Is IOPS (I/O Operations Per Second)

Q

What Is IOPS (I/O Operations Per Second)?

✍: FYIcenter.com

A

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 INSERT Statements

IOPS Tests on INSERT Statements

⇑⇑ SQL Server Storage Tutorials

2019-08-08, 256👍, 0💬