April 8, 2002 at 5:31 pm
Hi all:
This is very strange. I do not know what the cause is. The problem that I am facing is that mem usage with SQL SERVER process keeps creeping up. When I start SQL SERVER mem usually assigned to SQL SERVER is around 140 - 150 MB. So much to start with. What is more strange that it keeps increasing with the passage of time till it gets to 700 MB and in rare cases to 1GB+ and after some time the SERVER restarts it self. I am at a loss to find what is the cause of this problem. Also, the same server serves as the WEBSERVER. This is an experimental configuration just to check if get performance gain on some applications that we are running. The Operating System is Windows 2000 Advanced Server. Any pointers and guesses would be appreciated. thanks in advance.
April 8, 2002 at 7:05 pm
There is nothing wrong with the memory usage increasing, by design SQL will acquire and use as much memory as it can, releasing some back to the OS if needed. You can see this for yourself by starting the service, then running a select * against a large table. You'll see the memory used increase as the data gets cached. If you continue doing selects you'll typically see no further increase. Try a different table and you'll see the memory go up again. Server rebooting on it's own is a bad thing, have you checked the event log to see what is happening? Running anything besides SQL on the server is not a good idea.
Andy
April 30, 2002 at 10:13 am
I have experienced something similar before i installed SQLServer service pack. Try installing latest service pack.
Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.
April 30, 2002 at 10:50 am
I had something like this. With only about 1.2GB of databases on a server with 2GB, I had SQL Server increase to 1.7GB and hold there over a few months. Now I know it might be caching tons of query plans as well, but that seems high. Of course, the server ran fine. This was SS2K, SP1
Steve Jones
April 30, 2002 at 7:58 pm
Memory usage is not unusual as this is where it augments access speeds. However
quote:
after some time the SERVER restarts it self
Is unusual, try the latest SP for sure and see if goes away.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply