Categories:
Cloud (204)
Entertainment (11)
Facebook (43)
General (50)
Life (31)
Programming (64)
Technology (430)
Testing (4)
Tools (488)
Twitter (5)
Wearable (26)
Web Design (44)
Collections:
Other Resources:
"sqlio -s300" - Get Stable Test Result
How long should I run SQLIO to get stable test result?
✍: FYIcenter.com
Setting the Number of Seconds to Run option, "sqlio -s",
to get stable test result really depends on your environment.
There are many factors that may impact the stability:
If you are not able to control the stability of the environment, you can increase the Number of Seconds to Run option to be long enough to average out the instability of the environment.
1. Run the test for 10 seconds, repeat for 3 times, and record the primary test measurements:
C:\fyicenter\SQLIO>sqlio -LS -b16 -s10 IOs/sec: 128.10 Avg_Latency(ms): 7 C:\fyicenter\SQLIO>sqlio -LS -b16 -s10 IOs/sec: 140.98 Avg_Latency(ms): 6 C:\fyicenter\SQLIO>sqlio -LS -b16 -s10 IOs/sec: 149.10 Avg_Latency(ms): 6
2. Run the test for 60 seconds and repeat for 3 times:
C:\fyicenter\SQLIO>sqlio -LS -b16 -s60 IOs/sec: 145.34 Avg_Latency(ms): 6 C:\fyicenter\SQLIO>sqlio -LS -b16 -s60 IOs/sec: 119.90 Avg_Latency(ms): 7 C:\fyicenter\SQLIO>sqlio -LS -b16 -s60 IOs/sec: 144.50 Avg_Latency(ms): 6
3. Run the test for 300 seconds and repeat for 3 times:
C:\fyicenter\SQLIO>sqlio -LS -b16 -s300 IOs/sec: 153.26 Avg_Latency(ms): 5 C:\fyicenter\SQLIO>sqlio -LS -b16 -s300 IOs/sec: 147.86 Avg_Latency(ms): 6 C:\fyicenter\SQLIO>sqlio -LS -b16 -s300 IOs/sec: 146.17 Avg_Latency(ms): 6
As you can see, we need to run the test for 300 seconds (5 minutes) to get a stable result.
⇒ "sqlio -kR -b64" - Reading 64-KB Block Test
⇐ Tuning SQLIO for Your Environment
2019-05-14, 1053🔥, 0💬
Popular Posts:
What are Control Connection and Data Connection used in FTP protocol? FTP protocol uses two independ...
What are the steps to insert Dynamic Fields in Microsoft Word? I want to insert the chapter heading ...
Why I am getting the "FTP over TLS is not enabled, users cannot securely log in" waring on my FileZi...
How to troubleshoot Fitbit device sync issue? My Fitbit device is connected to my Windows computer, ...
Why I am getting the "FTP over TLS is not enabled, users cannot securely log in" waring on my FileZi...