Sql server process memory question

[caspervt]

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. The antivirus is
MCaffee

[Greg D. Moore \(Strider\)]

<ca******@gmail.comwrote in message
news:11*********************@p10g2000cwp.googlegro ups.com...

>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. The antivirus is
MCaffee

What is growing by 200MB a day? Memory? disk? If disk, which, the data or
the log?

[Erland Sommarskog]

(ca******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[caspervt]

On 15 Feb., 17:38, "Greg D. Moore \(Strider\)"
<[e-mail]:

<[e-mail] in message

news:11*********************@p10g2000cwp.googlegro ups.com...

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. The antivirus is
MCaffee

What is growing by 200MB a day? Memory? disk? If disk, which, the data or
the log?

The amount of memory is growing. Currently 2 processes one 400mb the
other 1,4GB. The later is growing by 200mb pr day