Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to limit the number of processor SQL servur uses. RE: How to limit the number of processor SQL servur uses.

  • March 30, 2009 at 4:21 am

    #968198

    I have one server with 8 CPU (CPU0, CPU1... CPU7) , I am using 2005 Standard Sql version so I am limited to 4 CPU.

    I have 2 instances running on my server, how can I tell one instance, using affinity mask, to only use CPU4 to CPU7?

    Kindest Regards,

    egpotus DBA