Azure server high memory composition

AB123 351 Reputation points
2021-10-14T08:16:45.297+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,605 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,053 questions
0 comments
Accepted answer
  1. AB123 351 Reputation points
    2021-10-21T07:59:54.847+00:00

    By setting a paging file fixed it!

    1 person found this answer helpful.

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. 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.

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

    1 person found this answer helpful.
    0 comments
  2. 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.

    1 person found this answer helpful.
    0 comments
  3. 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 Guide

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

    0 comments
  4. AB123 351 Reputation points
    2021-10-14T08:32:05.29+00:00

    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?