Post reply

What percentage of memory utilization is server bottleneck?

  • August 8, 2014 at 3:16 am

    #288900

    We are using Virtual machine 32bit OS, created on Windows server 2008 64 bit, and Installed SOL server 2005 32 bit. there is memory (RAM) utilization high as 70% and above:(. Is this a bottleneck?

    What percentage of memory utilization in server is bottleneck?

    Ali
    MCTS SQL Server2k8

  • 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

  • August 8, 2014 at 4:03 am

    #1736350

    GilaMonster (8/8/2014)

    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?

    To add, 32 bit has some peculiarities that make it WAY more likely that memory is or can be an issue with performance. But there are a LOT of things that can cause performance issues on SQL Server. Way more than can be covered in some forum posts.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • September 18, 2014 at 3:26 am

    #1746322

    GilaMonster (8/8/2014)

    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?

    Thank you very much GilaMonster

    Ali
    MCTS SQL Server2k8

  • September 18, 2014 at 3:27 am

    #1746323

    thanks to all and TheSQLGuru

    Ali
    MCTS SQL Server2k8

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

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