• You just have to use sp_configure:

    EXEC sp_configure 'show advanced option', '1';

    RECONFIGURE;

    EXEC sys.sp_configure;

    That will show you all the advanced options to just see the affinity mask for I/O you do this:

    EXEC sys.sp_configure @configname = 'affinity I/O mask';

    --or

    EXEC sys.sp_configure @configname = 'affinity64 I/O mask';

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning