SQL Server 2022 Memory Consumption

  • I have migrated to SQL Server 2022 from SQL Server 2014 and after migration I have observed that it is consuming more memory than before. Memory is going almost 80-90%.

    We have same configuration, there is not memory caping on SQL Server 2022 and there was no caping on SQL Server 2014. We have same indexes created DB is also same in both the servers.

    When we use SQL Server 2014 then everything is working fine but when we use 2022 then after few minutes memory consumption goes to 80-90%. We are performing same operations with both servers.

    Does SQL Server 2022 takes more memory or there is anything we can do to resolve this issue?

  • I have nothing good to say about SQL Server 2022.  Any benefits have been outweighed by things like you describe and some seriously slow running code.  MS broke things starting in 2019.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Why are you not memory capping SQL Server in order to leave some RAM reserved for OS / other applications ?

  • Hello Jo,

    Yes we can do memory capping but the whole point is we were not doing that in SQL Server 2014 so what went wrong in SQL Server 2022 that it is taking more memory now. That's why i wanted to know.

  • did you switch from 32-bit version to 64-bit version of the software ? ( We're using the 64-bit versions whenever available )

    64-bit versions have always been advised to set max-memory-size !

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • We are also using 64-bit version.

  • SQL Server uses memory to cache data, if you don't set a maximum it is likely to use all the memory on the machine, including memory required by the operating system. You should set a maximum memory limit

Viewing 7 posts - 1 through 6 (of 6 total)

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