SQL Server 2022 Memory Consumption

Question

SQL Server 2022 Memory Consumption

Ashwani

SSC Enthusiast

Points: 114
More actions
August 22, 2024 at 8:38 am

#4448248

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?

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

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

Jeff Moden SSC Guru Points: 1004361 More actions · Answer 1

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)

Jo Pattyn SSC-Dedicated Points: 32348 More actions · Answer 2

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

Ashwani SSC Enthusiast Points: 114 More actions · Answer 3

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.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

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

Ashwani SSC Enthusiast Points: 114 More actions · Answer 5

Ashwani

SSC Enthusiast

Points: 114

August 22, 2024 at 1:05 pm

#4448356

We are also using 64-bit version.

Jonathan AC Roberts SSCoach Points: 18355 More actions · Answer 6

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