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,759 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,173 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: Newest
Most helpful Newest Oldest
  1. Limitless Technology 39,376 Reputation points
    2021-10-19T15:19:39.947+00:00

    Hi @AB123

    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://learn.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--

    0 comments
  2. Erland Sommarskog 101.4K 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. 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
  4. AB123 351 Reputation points
    2021-10-14T08:33:28.337+00:00

    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?

    0 comments