sql server使用非常少的内存 [英] sql server using very less memory

问题描述

我们使用的是sql 20014.系统规格：4CORE& 128GB RAM。我们配置了最大内存110460 mb  &安培;最小内存为1024 kb。

用户抱怨SQL性能非常慢。
当我们使用62％内存检查任务管理器sql.exe时，
。 b $ b当我尝试使用以下查询检查内存时显示72 gb内存正在使用。

选择

（physical_memory_in_use_kb / 1024）Memory_usedby_Sqlserver_MB，

（locked_pa​​ge_allocations_kb / 1024）Locked_pa​​ges_used_Sqlserver_MB，

（total_virtual_address_space_kb / 1024）Total_VAS_in_MB，

process_physical_memory_low，

process_virtual_memory_low
$来自sys的b $ b。 dm_os_process_memory



o / p：

Memory_usedby_Sqlserver_MB = 72720 mb。

$
不知何故确认SQL Server没有使用已配置的内存。 
$
如何确保sql server使用高内存？请帮忙。我需要尽快解决这个问题。



谢谢，

Jo¥

---

pols

Hi,

we are using sql 20014. system specifications :4CORE &128GB RAM . We configured max memory 110460 mb  & min memory as 1024 kb.
Users complaining that SQL peformance is very slow.
when we checked the task manager sql.exe utilising 62 % memory.
when i tried to check the memory using below query its showing that 72 gb memory is using.
select
(physical_memory_in_use_kb/1024)Memory_usedby_Sqlserver_MB,
(locked_page_allocations_kb/1024 )Locked_pages_used_Sqlserver_MB,
(total_virtual_address_space_kb/1024 )Total_VAS_in_MB,
process_physical_memory_low,
process_virtual_memory_low
from sys. dm_os_process_memory

o/p:
Memory_usedby_Sqlserver_MB =72720 mb.

somehow it is confirmed that SQL Server is not using configured memory. 
How to make sure the sql server using high memory? please help. I need to ressolve this as soon as possible.

Thanks,
Jo

---

pols

推荐答案

服务器上是否有其他进程消耗SQL Server外部的内存？这可能是SQL Server没有达到全部剂量的原因。

Are there other processes on the server consuming memory outside SQL Server? That could be the reason that SQL Server is not getting its full dosage.

但也可能是SQL Server不需要更多内存。也就是说，访问相同的72 GB数据。


或者你得出结论，SQL Server正在执行大量的物理I / O，这就是为什么响应时间很慢？如果没有，我的直觉是你在错误的地方寻找解决性能不佳的问题。

But it could also be that SQL Server does not need more memory. That is, the access to the same 72 GB of data.
Or have you concluded that SQL Server is performing a lot of physical I/O and that is why is response time is slow? If not, my gut feeling is that you are looking in the wrong place for the explanation for the poor performance.

性能不佳的最常见原因是编写错误的查询和不恰当的索引。在这种情况下，您需要识别慢查询。

The most common reason for bad performance is badly written queries and inappropriate indexing. In this case you need to identify the slow queries.

这篇关于sql server使用非常少的内存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！