Table for IOPS Tests on INSERT Statements

Q

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

✍: FYIcenter.com

A

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:

CREATE TABLE FYI_INT (QUANTITY INT)

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

⇑⇑ SQL Server Storage Tutorials

2019-08-08, 159👍, 0💬