Posted by Erland Sommarskog on 02/15/07 22:35

(caspervt@gmail.com) writes:
> I got a Small Business Server 2003 running. It has 2 sqlserver
> processes. One of them is growing by 200mb every day. Does anyone have
> a clue to this. It's serving as a printserver, fileserver and exchange
> server. There is no specific use of the sqlserver.

SQL Server likes to grab as much memory it can, since memory is good for
cache, and cache is good for performance. If other processes on the machine
needs the memory, SQL Server will yield, but it may not yield fast
enough. Since SQL Server is not alone on this box, it could be a good
idea to set an upper limit for the memory. You can do this from Enterprise
Manager.

> The antivirus is MCaffee

You should exempt mdf, ndf and ldf files from virus checl, as backup
files.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Merging contents of one db to another huge db.
• Prev in forum: Re: Performance
• Thread view: Re: Sql server process memory question

[Reply to this message]