By setting a paging file fixed it!
Azure server high memory composition
Hi All,
My server in azure i
s using High memory usage how do reduce this? This server shouldn't be as high as it is for what its used for barely should be using 82%
any ideas?
6 additional answers
Sort by: Most helpful
-
Tom Phillips 17,716 Reputation points
2021-10-14T12:14:51.447+00:00 You need to set the "max server memory" to a reasonable value to prevent page swapping.
-
Erland Sommarskog 100.8K Reputation points MVP
2021-10-14T21:39:17.593+00:00 It seems that you have (at least) two SQL Server instances on the machine. In this case, you should probably set "max server memory" for both. If they are equally loaded, I would set it 7000 for both, but you may want a different distribution. But the total should be around 14000, to leave some space for the OS.
If you leave both instance with the default setting, they will be fighting constantly over the memory.
-
Olaf Helper 40,576 Reputation points
2021-10-14T08:24:47.277+00:00 how do reduce this?
Believe me, you don't want that, because that would cause performance issues.
It's by design and intendent that SQL Server uses as much memory as it needs and as it can get, see Memory Management Architecture GuideYou can use the max memory setting to limit the upper usage, see Server memory configuration options
-
AB123 351 Reputation points
2021-10-14T08:32:05.29+00:00 Hi
How do I get the server to stop using this:
How do I get the server to stop using modified memory.
I think this is the issue because we recently migrated our MIS server from on prem to azure and this doesn't exist on the on prem server but on Azure it does?