Post reply

rebuild increases memory

  • April 13, 2014 at 9:58 pm

    #285690

    Hello,

    it is possible to handle increasing memory by rebuild and update statistics ? Every weekend is increased about 20-30GB.

    After fill to full memory is use pagefile, what I dont want.

    Any Idea ?

    Thank you

  • April 14, 2014 at 12:31 am

    #1705635

    Not clear, what exactly are you looking for? Are you facing any issue on the server?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • April 14, 2014 at 12:54 am

    #1705639

    SQL doesn't use the page file, and memory usage is capped by max server memory.

    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

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

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