Have Geek Brain

What caused the private bytes on SQL Server 2005?

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

only process 51 with "runnable" status. Click for 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

Call connections have been closed.

Any hint?

+1


a source to share


2 answers


1.7 GB is a 2 GB user mode address space (default) less than 384 MB. By default, SQL Server leaves 384 MB.

If you have / 3GB and 3GB RAM, it will use 2.7GB.



See this article, KB 316749 , which applies to SQL 7 prior to SQL 2005. Oddly enough, I haven't found this information elsewhere, even with the SQL Server memory documents. It is easy to reproduce.

+2


a source


SQL Server manages its own memory pool and releases memory back to the OS under memory pressure (down to the minimum set in the SQL configured values.



Therefore, you do not need to worry.

0


a source






More articles:


All Articles