471,049 Members | 1,898 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Sql server process memory question

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

Feb 15 '07 #1
3 2400

<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?

Feb 15 '07 #2
(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
Feb 15 '07 #3
On 15 Feb., 17:38, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.comwrote:
<caspe...@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?
The amount of memory is growing. Currently 2 processes one 400mb the
other 1,4GB. The later is growing by 200mb pr day

Feb 16 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Justin Lazanowski | last post: by
10 posts views Thread by tshad | last post: by
6 posts views Thread by Daniel Walzenbach | last post: by
25 posts views Thread by abhinav | last post: by
28 posts views Thread by Jon Davis | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.