Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DeepGround
Yak Posting Veteran
73 Posts |
 Posted - 2011-06-14 : 12:47:55
|
| Hello,After installing R2 I am now getting the message "The affinity mask specified conflicts with the IO affinity mask specified." When I have any I/O affinity boxes checked on the same CPU as the Processor affinity.Here is Microsoft's explanation:The 'affinity mask' and 'affinity I/O mask' configuration values of SQL Server should not conflict. Performance may suffer if you choose to affinitize a processor for both SQL Server worker thread scheduling and for I/O processing. Therefore, you should ensure that the configuration values are not set for the same processor. The same recommendation applies to the 'affinity64 mask' and 'affinity64 I/O mask'.My Question is, what if I do not have any CPU's to provide I/O other than the one providing the processing?This was never a problem before. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-06-14 : 19:14:31
|
| You only have one CPU?If you have Affinity or I/O Affinity turned off (All 0's), then the system performs the processing or I/O or whatever CPU it can find available.=======================================I have never met a man so ignorant that I couldn't learn something from him. -Galileo Galilei, physicist and astronomer (1564-1642) |
 |
|
|
DeepGround
Yak Posting Veteran
73 Posts |
Posted - 2011-06-15 : 10:59:02
|
| I have 80 CPUs. They are all assigned for SQL worker processing. I can not afford to add 80 more CPUs for I/O. |
|
|
|
|
|
|
Affinity mask conflicts with the IO affinity mask