Table for IOPS Tests on INSERT Statements


How to design a database table to perform IOPS tests on INSERT Statements?



In order to for perform IOPS tests on INSERT Statements, we should start with a simplest table first using minimum database functionalities.

Here is an example of database table, FYI_INT, with only 1 column:


This FYI_INT has no primary key, no index, no constrains, and no default values.

Each record has only 1 field called QUANTITY, which stores an integer using 4 bytes.

If we insert 1,000,000 records in this table, the database will grow with 4,000,000 bytes or 4 MB.


Input Operation Test with INSERT Statements

What Is IOPS (I/O Operations Per Second)

IOPS Tests on Azure SQL Database with INSERT

⇑⇑ SQL Server Storage Tutorials

2019-08-08, 1590🔥, 0💬