Home Forums SQL Server 2012 SQL 2012 - General Instance won't start after changing Processor Affinity RE: Instance won't start after changing Processor Affinity

  • March 15, 2013 at 12:54 pm

    #1597631

    GilaMonster (3/15/2013)

    If you want to balance the CPU load of the instances, the windows resource manager's a better choice

    http://technet.microsoft.com/en-us/library/cc755056.aspx

    Firstly you can do more granular limits, second, because if the other instances are doing nothing at all, why shouldn't the one get most of the CPU, it's not preventing the others from working, they're idle. If all 4 are working heavily, then the limits kick in.

    Can you post the error log of one of the times the startup failed? The entire error log please.

    Also, 4GB for the OS might be a little on the low side for a 32 GB server. Monitor, make sure that the available memory (perfmon counter) doesn't drop below 600MB-1GB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass