Home Forums SQL Server 2012 SQL 2012 - General What percentage of memory utilization is server bottleneck? RE: What percentage of memory utilization is server bottleneck?

  • August 8, 2014 at 3:21 am

    #1736337

    Wrong question

    SQL will use all the memory that it's allowed to use, up to 100% of what's on the machine. You need to set its limits. If you don't, it will try to use everything.

    SQL uses a lot of memory, that's by design and how it's intended to work. Using lots of memory is not a problem.

    Why on earth are you using 32 bit?

    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