检查服务器上的内存更改 [英] Check Memory changes on Server

问题描述

我在IAAS上运行SQL 2016 Azure。 

I am running SQL 2016 Azure on IAAS. 

我们遇到了性能问题并在检查时看来服务器内存  （而不是SQL分配）已从110GB降至55GB。

We were experiencing performance issues and when examining it it appears that the server memory  (not SQL allocation) has been dropped from 110GB to 55GB.

是否有任何日志会告诉我内存何时更改？我查看了Windows系统日志，但不知道要搜索什么。

Are there any logs which will tell me when the memory was changed? I've looked in the Windows sytem logs, but dont know what to search for.

谢谢，

Zoe

推荐答案

嗨Zoe，

您正在运行哪个VM实例？应该是这样的值：D16s v3

Which VM instance are you running? Should be a value of something like: D16s v3

您目前使用的是Azure监视器吗？  来自Azure Monitor的虚拟机的丰富见解 

Are you currently using Azure Monitor? Rich insights for virtual machines from Azure Monitor 

如果这是启用的，那么您可能有历史数据来查明内存分配何时发生变化。如果没有，那么eventvwr可能在系统日志中包含引导事件，其中包含内存和CPU详细信息。 

If this is is enabled then there is a chance that you have the historical data to find out when memory allocation has changed. If not, then perhaps eventvwr may have boot events in the system log with memory and CPU detail included. 

还有一种方法可以查看
虚拟机重启日志，其中可能包含有关内存分配更改的信息。 

There also is a method of viewing the VM Reboot Logs which might contain information with regard to changes to memory allocation. 

服务器故障论坛的其他信息：

Additional information from Server Fault forum:

如何监控Azure上的VM内存使用情况？

这篇关于检查服务器上的内存更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！