SQL Server 实际使用了多少 RAM? [英] How much RAM is SQL Server actually using?

问题描述

我正在调试我的一个应用程序，并注意到我的 SQL Server 2005 x64 机器(在 Windows 2003 R2 x64 上运行)上的 RAM 被锁定，甚至进入了分页文件.

I am debugging one of my apps and noticed that the RAM on my SQL Server 2005 x64 box (running on a Windows 2003 R2 x64 ) is pegged and even going into the paging file.

我知道 SQL Server 2005 x64 只会抓取它所能抓取的一切，所以这可能是正常的 (???).如何查看它实际使用了多少内存?

I understand that SQL Server 2005 x64 just grabs everything it can, so this might be normal (???). How can I check how much memory it is actually using?

推荐答案

您需要运行 Perfmon(开始->控制面板->管理工具->性能).我相信，您想要的计数器在 SQL Server:Memory Manager 中.目标服务器内存是在需要时允许占用的内存量，总服务器内存是当前使用的内存量.如果您点击解释"，它会弹出一个包含详细信息的框.

You need to run Perfmon (start->control panel->administrative tools->performance). The counters you want, I believe, are in SQL Server:Memory Manager. Target Server Memory is how much it's allowed to take if needed, Total Server Memory is how much it's currently using. If you click on Explain it'll pop open a box with the details.

默认情况下，它是无上限的，应该使用除几 GB 内存之外的所有内存(它留给操作系统使用).但是，有各种错误和内存泄漏会导致它进入分页.

By default it's uncapped, and should use all but a couple gb of memory (it leaves that for the OS). However, there are various bugs and memory leaks that can cause it to go into paging.

这篇关于SQL Server 实际使用了多少 RAM?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！