August 22, 2024 at 8:38 am
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?
August 22, 2024 at 8:47 am
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
Change is inevitable... Change for the better is not.
August 22, 2024 at 9:48 am
Why are you not memory capping SQL Server in order to leave some RAM reserved for OS / other applications ?
August 22, 2024 at 9:59 am
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.
August 22, 2024 at 11:23 am
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
August 22, 2024 at 1:05 pm
We are also using 64-bit version.
August 23, 2024 at 8:42 pm
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