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 -p" - CPU Number for Affinity
What is the CPU Number for Affinity option, "sqlio -p"?
✍: FYIcenter.com
The CPU Number for Affinity option, "sqlio -p", specifies a specific CPU to run SQLIO.
The default value is "", all CPUs. In this case, all CPUs are used.
Example 1 - Run SQLIO with the first CPU:
C:\fyicenter\SQLIO>sqlio -p0 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run affinity on cpu number 0 initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 2337.71 MBs/sec: 4.56
Example 2 - Run SQLIO with the 4th CPU:
C:\fyicenter\SQLIO>sqlio -p3 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run affinity on cpu number 3 initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 1957.83 MBs/sec: 3.82
Example 3 - Run SQLIO with all CPUs:
C:\fyicenter\SQLIO>sqlio 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 3852.54 MBs/sec: 7.52
As you can see, when using all CPUs, the throughput is better as we expected.
⇒ "sqlio -a" - CPU Mask for Affinity
⇐ "sqlio -o" - Outstanding Tests in Asynchronous Queue
2019-05-14, 854🔥, 0💬
Popular Posts:
How do I tell what version of PowerPoint my computer is using? You can determine the version number ...
How to make continuous page numbering in a FrameMaker book? I want to see the page number continues ...
How to add a new layout to the slide master in PowerPoint? In my PowerPoint presentation, I need to ...
How to download FrameMaker 2017 Release for my Windows computer? I want to try it. You can follow th...
Sometimes I see special symbols are showing up at the end of each paragraph in my Microsoft Word doc...