• Post the results of the following two queries from BOTH servers for each instance:

    select name, value, value_in_use

    from sys.configurations

    where name = 'affinity mask';

    select

    dos.scheduler_id,

    dos.cpu_id,

    dos.is_online,

    don.cpu_affinity_mask,

    don.online_scheduler_count,

    don.online_scheduler_mask,

    don.memory_node_id

    from sys.dm_os_schedulers as dos

    inner join sys.dm_os_nodes as don

    on dos.parent_node_id = don.node_id

    where dos.status = 'visible online';

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]