在SQL Server 2012中看到高内存使用情况 [英] Seeing High Memory Usage In SQL Server 2012

问题描述

我们刚刚安装了SQL Server 2012并实现了AAG.它是Windows 2012上的2节点群集.服务器是使用VMWare 5.1的VM.由于某种原因，我看到最大的内存使用量为15演出.该服务器具有16 GB的内存，我将SQL中的最大内存设置为12gb，将最小内存服务器设置为8 gig. 对于SQL这样最大程度地消耗内存，这是正常的吗?该服务器上没有其他应用程序在运行，并且活动很少.

We have just installed SQL Server 2012 and implemented AAG. It is a 2 node cluster on Windows 2012. The servers are VMs using VMWare 5.1. For some reason, I am seeing the memory usage max out at 15 gigs. The server has 16 GB of memory and I have set the max memory in SQL to be 12gb and the min memory server to be 8 gigs. Is this normal for SQL to max out on the memory like that? There are no other applications running on that server and at the time there is very low activity.

推荐答案

SQL Server将非常​​消耗内存，并在属性设置的限制范围内从OS中获取所需的内存.您还不清楚是否15GB的内存使用量"是用于整个服务器还是sql服务器本身?如果将最大内存设置为12后，如果使用的是15GB，我会感到惊讶.如果您的SQL Server使用的是12GB，而其他操作系统使用的是3GB，那么这对我来说听起来很正常.

SQL Server will be very memory 'hungry' and take what it can from the OS within the limits set in the properties. You haven't been totally clear as to whether your 'memory usage' of 15GB is for the server as a whole or for the sql server itself? I would be surprised if it was using 15GB after you have set the max memory to 12. If your SQL server is using 12 and the rest of your OS is using 3GB then this sounds very normal to me.

确定SQL Server使用的内存并不像查看Windows任务管理器那样简单.正如我提到的那样，它将使用OS所能提供的功能，以避免以后再声明更多内存时产生任何开销，即使它尚未使用全部内存也是如此.

Determining what memory SQL server is using is not as simple as looking at the Windows Task Manager. As I mentioned, it will take what it can from the OS to avoid any overhead in claiming more memory later, even if it isn't using it all yet.

我们的服务器使用多达64GB的内存，并且当我们倾向于分配比服务器总数少4GB的SQL Server时，剩下的4GB用于Windows.然后，我希望大多数服务器在任何时候都只能显示1或2GB的可用内存.这确实使了解内存是否是SQL Server的瓶颈变得更加困难，因为您将需要使用性能计数器作为user2665372的状态.请参阅此以获取更多详细信息: SQL Server实际使用了多少RAM? /a>

We have servers using up to 64GB of memory and when we tend to allocate SQL Server 4GB less than the server total, leaving that 4GB for Windows. I would then expect most servers to only show 1 or 2GB free memory at all times. This does make it more difficult to understand whether memory is a bottleneck within SQL Server, for that you will need to use the performance counters as user2665372 states. See this for further details: How much RAM is SQL Server actually using?

这篇关于在SQL Server 2012中看到高内存使用情况的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！