November 26th, 2003, 02:26 PM
MS SQL a memory hog?
I'm new to SQL Server as I've just obtained the developer edition to practise writing .NET apps with. I installed ok as I'm also reading a book, but one problem i'm having isn't addressed in any book i've read to date.
When MS SQL Server 2000 installs it generates 3 services, one of them being the sqlserver.exe service. The problem I am having is that after 10 minutes or so the sqlserver.exe service ends up taking 95-99% of system resources, to the point where my computer slows or even locks up. I'm trying to run this sql server as a test on my home pc which also has VS.NET installed, I want to have everything on one pc as i'm just testing and learning.
My setup. Intel P4 2.4GHZ with 512mb ram. Is it normal for sql server to hog all the system resources? Any idea what is causing this behaviour?
I've tried adjusting the memory using the enterprise manager but no matter how little memory i specify it doesn't stop the sqlserver.exe service from hogging my system resources. Any suggestions?
November 27th, 2003, 03:56 PM
Did you restart the SQL server service after making the changes in Enterprise Manager?
November 28th, 2003, 03:47 AM
Service packs installed? (Both OS and SQLServer)
December 1st, 2003, 12:30 PM
SQL Server by design will try to use all available memory, but it will also release memory back to the OS when it's needed. The memory limits you set in EM should work for you though.
December 13th, 2003, 06:37 PM