Using: SQL Server 2008 R2
Under what circumstances would you set the Affinity Mask and Affinity I/O Mask options in sp_configure in SQL Server?
We are currently running on a machine with 16 cores dedicated to SQL Server. We are also seeing slowness in our I/O operations. Some writes (insert 1 row) can take up to 500 ms. We would like to support many writes per second. The process that inserts data can spawn up to 4 threads for executing the insert operations.
I'm considering dedicating 8 cores to the affinity mask and the other 8 to affinity I/O mask.
Is this recommended?