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 -a" - CPU Mask for Affinity
What is the CPU Mask for Affinity option, "sqlio -p"?
✍: FYIcenter.com
The CPU Mask for Affinity option, "sqlio -p", specifies a group of CPUs, using a binary number to mask them, to run SQLIO.
The default value is "", all CPUs. In this case, all CPUs are used.
Example 1 - Run SQLIO with the first CPU, 8 = 0x8 = 0b1000:
C:\fyicenter\SQLIO>sqlio -a8 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run affinity mask is 0x8 (8) initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 2596.15 MBs/sec: 5.07
Example 2 - Run SQLIO with the first CPU and the third CPU, 10 = 0xa = 0b1010:
C:\fyicenter\SQLIO>sqlio -a10 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run affinity mask is 0xa (10) initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 2246.17 MBs/sec: 4.38
Example 3 - Run SQLIO with the last 3 CPUs, 7 = 0x7 = 0b0111:
C:\fyicenter\SQLIO>sqlio -a7 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run affinity mask is 0x7 (7) initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 3605.25 MBs/sec: 7.04
Example 4 - Run SQLIO with all 4 CPUs, 15 = 0xf = 0b1111:
C:\fyicenter\SQLIO>sqlio -a15 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run affinity mask is 0xf (15) initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 3466.34 MBs/sec: 6.77
As you can see, the impact of running more CPUs is not obvious. May be we should re-test with multiple threads and multiple outstanding tests in the asynchronous queue.
⇐ "sqlio -p" - CPU Number for Affinity
2019-05-14, 905🔥, 0💬
Popular Posts:
How to make continuous page numbering in a FrameMaker book? I want to see the page number continues ...
What is Microsoft Office 365? Office 365 is a cloud service offered by Microsoft that provide produc...
What is "Microsoft Access Outlook Add-in for Data Collection and Publishing" COM Add-in in Outlook 2...
How to download Google Chrome 31? I heard it has some really nice features for Web developers. If yo...
How to turn on or off comments? I have a PowerPoint presentation which has comments entered by diffe...