Categories:
Cloud (204)
Entertainment (11)
Facebook (43)
General (50)
Life (31)
Programming (64)
Technology (398)
Testing (4)
Tools (488)
Twitter (5)
Wearable (26)
Web Design (44)
Collections:
Other Resources:
SQLIO Related Terminology
SQLIO Related Terminology:
Affinity - Affinity refers to individual CPUs in a multi-CPU system. You can specify which single CPU to use by the "-p" option, or which group of CPUs to use by the "-a" option.
Asynchronous Queue - SQLIO supports asynchronous I/O tests within a single thread You can control the queue depth by the "-o" option. "-o0" is the default, which means no queuing, tests are performed asynchronously.
Block - Block is a single chunk of data used by SQLIO as a unit of test for reading or writing data from or to the storage device. The block size is specified by "-b" option in KB.
Data File - Data file is a file stored on target storage device to be used to for I/O tests. You can specify the data file name as the SQLIO command argument. If not specified, the default data file of "testfile.dat" from the current directory will be used.
Latency - Latency is the time took to perform a given I/O operation on a single block. The Latency is related to Throughput IOs/sec as shown below in an ideal parallel threading environment:
Latency = 1000 * Throughput IOs/sec / Threads
Stripe Factor - Stripe Factor is the number of blocks the next test unit should jump over. Stripe Factor creates a stripe pattern of data blocks used in consecutive tests on a test run. The Stripe Factor is specified by the "-f" option.
Test Run - Test Run is a step in main test loop of a test thread. A single Test Run may perform 1 or more test units, depending on the test size specified by the "-i" option.
Thread - Thread is a line of execution in parallel to other execution lines. The number of threads to use is specified by the "-t" option.
Throughput - Throughput is the number of operations that can be performed within a given period of time.
Throughput IOs/sec - Throughput IOs/sec is the number of I/O blocks that are performed per second.
Throughput MBs/sec - Throughput MBs/sec is the number of MB of I/O data that are performed per second. Throughput MBs/sec is related to Throughput IOs/sec as shown below:
Throughput MBs/sec = Block Size KB/1000 * Throughput IOs/sec
SQLIO - SQLIO is a Disk Subsystem Benchmark Tool provided by Microsoft for free.
⇒ "sqlio -L" - Latencies from System/Processor Timer
✍: FYIcenter.com
2019-08-19, 852🔥, 0💬
Popular Posts:
How to view the document.xml file with a Web browser? Since the document.xml file contains text cont...
How to add ActiveX controls, like text command button, text box, check box, etc., to Presentation sl...
What is Microsoft Office 365? Office 365 is a cloud service offered by Microsoft that provide produc...
How to test I/O performance on INTEL SSDPEKKF256G8L SSD (Solid State Disk) with SQLIO? INTEL SSDPEKK...
How to unzip an XPS (XML Paper Specification, .xps) file? According to Microsoft documentation, an ....