是什么导致了 SQL Server 2005 上的 Private Bytes? [英] What caused a Private Bytes on SQL Server 2005?

问题描述

我的服务器是 Windows 2003 和 SQL Server 2005 Standard.3 GB 内存.运行我的客户端程序一段时间后，私有字节高达 1.7 GB 并且永不下降.

My Server is Windows 2003 and SQL Server 2005 Standard. 3 GB of RAM. After run my client program for a while a Private Bytes up to 1.7 GB and never come down.

仅处理状态为可运行"的 51.点击详情.

only process 51 with status "runnable". Click details.

create table #tmpDBCCinputbuffer (
[Event Type] nvarchar(512), 
[Parameters] int,
[EventInfo] nvarchar(512)) 
insert into #tmpDBCCinputbuffer exec ('DBCC INPUTBUFFER(51)') 
select [Event Info] from #tmpDBCCinputbuffer 

呼叫连接已关闭.

有什么线索吗?

推荐答案

1.7GB 是 2GB(默认)用户模式地址空间少 384MB.SQL Server 默认保留 384 MB.

1.7GB is the 2GB (default) user mode address space less 384MB. SQL Server leaves the 384 MB by default.

如果您设置了/3GB 和 3GB RAM，它将使用 2.7GB.

If you had /3GB set and 3GB RAM, it would use 2.7GB.

请参阅这篇文章，KB 316749适用于 SQL 7 到 SQL 2005.奇怪的是，即使在 SQL Server 内存白皮书中，我也没有在其他任何地方找到此信息.不过，它很容易重现.

See this article, KB 316749 which applies to SQL 7 through to SQL 2005. Oddly, I've not found this information anywhere else, even with SQL Server memory whitepapers. It's easily reproducable though.

这篇关于是什么导致了 SQL Server 2005 上的 Private Bytes?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！