question

AB123-6633 avatar image
0 Votes"
AB123-6633 asked Cathyji-msft commented

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%

140449-screenshot-2021-10-14-at-90853-am.png


140440-screenshot-2021-10-14-at-91222-am.png



any ideas?

sql-server-generalwindows-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AB123-6633 avatar image
1 Vote"
AB123-6633 answered Cathyji-msft commented

By setting a paging file fixed it!

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AB123-6633,

Thanks for sharing the solution. Please mark the solution as answer this will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

1 Vote 1 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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 Guide

You can use the max memory setting to limit the upper usage, see Server memory configuration options

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AB123-6633 avatar image
0 Votes"
AB123-6633 answered Cathyji-msft commented

Hi

How do I get the server to stop using this:

140533-screenshot-2021-10-14-at-92828-am.png



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?


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AB123-6633,

How do I get the server to stop using this

This is by design, the memory composition graph is divided into four parts:

•In use
Memory is used by processes, drivers, or the operating system.
•Modified
Memory whose content must be written to disk before it can be used for another purpose.
•Standby
Memory that contains cached data and code that is not actively used.
•Free
Memory that is not currently in use and that will be repurposed first when processes, drivers, or the operating system needs more memory.

If you mean that you want to flush modified memory, please read the similar thread.


0 Votes 0 ·
AB123-6633 avatar image
0 Votes"
AB123-6633 answered

Hi

How do I get the server to stop using this:

140515-screenshot-2021-10-14-at-92828-am.png

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?



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
1 Vote"
TomPhillips-1744 answered TomPhillips-1744 edited

You need to set the "max server memory" to a reasonable value to prevent page swapping.

See:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hi @AB123-6633

Here are a few questions to ask when you troubleshoot the issue:

Is there a pattern to the issue? For example, does the high-CPU issue occur at a certain time every day, week, or month? If so, can you correlate this issue to a job, report, or user login?

Did the high-CPU issue start after a recent code change? Did you apply an update in Windows or in an application?

Troubleshoot high-CPU issues for Azure virtual machines
https://docs.microsoft.com/en-us/troubleshoot/azure/virtual-machines/troubleshoot-high-cpu-issues-azure-windows-vm


--If the reply is helpful, please Upvote and Accept as answer--

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.