SQL Server 2k5 内存消耗? [英] SQL Server 2k5 memory consumption?

问题描述

我有一个开发 vm，它运行 sql server 以及我的堆栈的其他一些应用程序，我发现其他应用程序的表现非常糟糕.在进行了一些挖掘之后，SQL Server 正在占用内存.经过快速的网络搜索后，我发现默认情况下，它会消耗尽可能多的内存，以便缓存数据并在其他应用程序请求时将其返回给系统，但这个过程通常不会发生得足够快，显然我的情况是一个常见问题.

I have a development vm which is running sql server as well as some other apps for my stack, and I found that the other apps are performing awfully. After doing some digging, SQL Server was hogging the memory. After a quick web search I discovered that by default, it will consume as much memory as it can in order to cache data and give it back to the system as other apps request it, but this process often doesn't happen fast enough, apparently my situation is a common problem.

不过有一个办法限制 SQL Server 允许拥有的内存.我的问题是，我应该如何设置这个限制.显然我需要做一些猜测和检查，但是有绝对的最小阈值吗?任何建议表示赞赏.

There however is a way to limit the memory SQL Server is allowed to have. My question is, how should I set this limit. Obviously I'm going to need to do some guess and check, but is there an absolute minimum threshhold? Any recommendations are appreciated.

我会注意到，开发人员机器有 2 gig 的内存，所以如果可能的话，我希望能够在 768 mb 或更少的内存上运行虚拟机.此 vm 将仅用于本地开发和测试，因此负载将非常小.在本地测试代码后，它会转到另一个环境，其中 SQL 服务器是专用的.我在这里真正想要的是关于最低要求的建议

I'll note that out developer machines have 2 gigs of memory so I'd like to be able to run the vm on 768 mb or less if possible. This vm will be only used for local dev and testing , so the load will be very minimal. After code has been tested locally it goes to another environment where the SQL server box is dedicated. What I'm really looking for here is recommendations on minimums

推荐答案

由于这是一个开发环境，我同意 Greg 的观点，只是使用试错法.让它完全正确并不是那么重要.

Since this is a development environment, I agree with Greg, just use trial and error. It's not that crucial to get it perfectly right.

但是如果你在 VM 中做了很多工作，为什么不至少给它 2GB 的一半呢?

But if you do a lot of work in the VM, why not give it at least half of the 2GB?

这篇关于SQL Server 2k5 内存消耗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！