问题

SQK VM的存储器利用率不准确来自Prism Central

  • 2021年10月20日
  • 2个答复
  • 45次观看
一种
徽章 +1

管理程序-ESXI 6.7U3

主要是Windows VM

我敢肯定，这是有充分理由的，这可能与SQL处理内存的方式有关，但是当我查看正在运行SQL的VM的Prism或Prism Central的内存使用情况时，这并不能准确地反映VM实际使用的内容。例如，如果我在VM内部启动任务管理器甚至PerfMon，它将报告的内存使用率为95％，而从Prism表示，它报告了VM使用25％。

我需要为SQL VM和应用程序服务器的集合生成报告，但我认为对于SQL VM，我将不得不提供PerfMon屏幕截图或其他内容。

谁能简单地向我解释为什么会发生这种情况？

HyperVisor - ESXi 6.7U3<\/p>

Mostly Windows VMs<\/p>

I\u2019m sure there\u2019s good reason for this and it's probably to do with the way SQL handles memory but when I check the memory usage from Prism or Prism Central for a VM that\u2019s running SQL it\u2019s not accurately reflecting what the VM is actually using.\u00a0 For example, from within the VM\u00a0if I fire up task manager or even perfmon it will report the memory usage at say 95% whereas from Prism it reports the VM\u00a0as using 25%.<\/p>

I need to generate a report for a collection of SQL VMs and application\u00a0servers but I think for the SQL VMs I'm going to have to provide perfmon screenshots or something.<\/p>

Can anyone explain to me\u00a0in simple terms why this is happening?<\/p>","quoteUsername":"Algon","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">

2个答复

p
秩

您好，这实际上与SQL Server管理内存的方式有关：在启动时，它将根据其要求锁定所有配置的内存使用。默认情况下，它将从操作系统中获取所有可用的内存，因此在任务管理器中的95％。

但这是虚拟内存，因此没有实际用途，从未触摸过物理内存，并且管理程序仅看到VM物理使用的内容。

这是所有内存管理应用程序的经典问题，另一个经常犯罪者是Java和应用程序服务器。

Hello, This actually has to do with the way SQL server manages memory: on startup it will lock all it configured memory use depending on its requirements. By default it will take all the memory available from the OS hence the 95% in the task manager.<\/p>

But this is virtual memory, so of there is no actual use, the physical memory is not ever touched, and the hypervisor sees only what is physically used by the VM.<\/p>

This is a classic issues with all memory managing applications, the other frequent offender being Java and application servers.<\/p>","quoteUsername":"PYBntnx","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">

一种
徽章 +1

你好 @pybntnx谢谢回复。

是的，这也是我的假设，除非我很确定SQL实际上正在使用\触摸的25％的物理内存。我可以从SQL内看到这一点，所以这是我感到困惑的地方。

Hi @PYBntnx<\/user-mention> thanks for the reply.<\/p>

Yes, this is my assumption also, except I\u2019m pretty sure SQL is actually using\\touching more then 25% of the physical memory.\u00a0 I can see this from within SQL, so\u00a0this is where I get confused.<\/p>","quoteUsername":"Algon","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">

回复


条款和条件
Learn more about our cookies.<\/a>","cookiepolicy.button":"Accept cookies","cookiepolicy.button.deny":"Deny all","cookiepolicy.link":"Cookie settings","cookiepolicy.modal.title":"Cookie settings","cookiepolicy.modal.content":"We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.<\/a>","cookiepolicy.modal.level1":"Basic
Functional","cookiepolicy.modal.level2":"Normal
Functional + analytics","cookiepolicy.modal.level3":"Complete
Functional + analytics + social media + embedded videos"}}}">
Baidu