Post reply

64Bit/8-dDualCore Hyperthread Processors/164gigs RAM

  • February 8, 2007 at 6:33 pm

    #122885

    I have 2 instances on this machine. Is there anything I have to do to activate the 164 gigs of RAM to be used? I see a check box for AWE, but this is 64-bit Wk2003 64-bit and SQL Server 2005 Enterprise 64-bit.

    The 8processor/dual core hyperthread shows 32 processors.

    Do I need to assign 24 of the processors to one instance and the other 8 to another? Should I let SQL Server manage that?

    Thanks and God Bless,

    ThomBeaux

    Thomas LeBlanc, MVP Data Platform Consultant

  • February 8, 2007 at 7:32 pm

    #688724

    You don't need the AWE on 64-bit machines running the 64-bit versions of the OS and SQL.  As for how to assign the processors, don't know.  My 64-bit machines ar dual processor quad-cores with 8 GB RAM.  They use all the available ram without using AWE.

  • February 8, 2007 at 11:33 pm

    #688734

    Check whether the sql server service account has "lock in memory" permission.

    You can assign a cpu using affinity mask option (see BOL)

    Good luck

  • February 9, 2007 at 7:42 am

    #688835

    Thanks foir the reply, our Network admin is checking for the "Lock in memory" setting.

     

    Thanks and God Bless,

    ThomBeaux

    Thomas LeBlanc, MVP Data Platform Consultant

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply