I/O affinity

  • Gail Shaw

    SSC Guru

    Points: 1004424

    colin.Leversuch-Roberts (8/23/2011)


    with 200GB of memory I can't believe this is an x32 system?

    Where do you see that?

    Min and max memory only set the limits for the buffer cache, in Denali I beleive this will change, however there are several memory pools and such which also take memory.

    Most of those memory pools are part of the buffer pool and hence constrained by max server memory. It's the non-pages memory that's outside (backup buffers, linked server drivers, CLR, thread stacks, extended procedures, a few others)

    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
  • ESAT ERKEC

    SSCertifiable

    Points: 5558

    No it dosent 32bit 64 bit

  • ESAT ERKEC

    SSCertifiable

    Points: 5558

    And thanks for your helppp

  • dan.brown1

    Ten Centuries

    Points: 1273

    In our current system - we have 2 Sockets, 16 cores, 32 logical CPU. So, as i understand it is 2 cpu per core? And we are planning to buy sql standard licences for 8 core, i.e., 16 cpu. In this scenario, i want to restrict my sql server affinity and IO affinity values. How should i make my SQL server to use all 16 cpu for both CPU and IO activities (without decreasing the CPU count from vm)? I tried setting up CPU and IO affinity values, but i can choose only either of them for each CPU.

Viewing 4 posts - 16 through 19 (of 19 total)

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