473,236 Members | 1,292 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,236 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 2453

<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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: w2jin | last post by:
Hi All Some my SQL Server are experience high memory usage. 1. How can I detect which process which process cause the big memory usage and not released? 2. Which sql server components in...
16
by: Justin Lazanowski | last post by:
Cross posting this question on the recommendation of an I have a .NET application that I am developing in C# I am loading information in from a dataset, and then pushing the dataset to a grid,...
2
by: Aravind | last post by:
Unable to consume Process reserved memory Hi , This is a Windows form application which interacts with the unmanaged C++ codes . In unmanaged c++ code we allocate around 130MB on the heap for...
1
by: Cy Huckaba | last post by:
We are running our company website on a win2k server running .NET framework 1.0 and IIS 5. The pages consist of mostly static content built from a combination of custom controls (dll is only 148k...
10
by: tshad | last post by:
I have been using the default session state (InProc) and have found that I have been loosing my information after a period of time (normally 20 minutes). Is there anyway to find out how much...
6
by: Daniel Walzenbach | last post by:
Hi, I have a web application which sometimes throws an “out of memory” exception. To get an idea what happens I traced some values using performance monitor and got the following values (for...
25
by: abhinav | last post by:
Hello guys, I am a novice in python.I have to implement a full fledged mail server ..But i am not able to choose the language.Should i go for C(socket API) or python for this project? What are the...
28
by: Jon Davis | last post by:
We're looking at running a memory-intensive process for a web site as a Windows service in isolation of IIS because IIS refuses to consume all of the available physical RAM. Considering remoting to...
5
by: Tenacious | last post by:
I am trying to shutdown a database server in the Application_End event handler on the Global.asax page. So far I am trying this only on the development server that comes with Visual Studio 2005....
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.