February 6, 2009 at 5:23 am
Hi Experts,
I have SQL Server 2000 box with 4GB Ram. The system becomes slow in time and the memory and CPU utilization reaches values upto 2GB and 50% respectively. How much is the permissible value for CPU amd Memory Usage ??
And is there any way to decrease the memory usage of SQL Server?
Please Help
TIA
February 6, 2009 at 5:57 am
Ratheesh.K.Nair (2/6/2009)
Hi Experts,I have SQL Server 2000 box with 4GB Ram. The system becomes slow in time and the memory and CPU utilization reaches values upto 2GB and 50% respectively. How much is the permissible value for CPU amd Memory Usage ??
And is there any way to decrease the memory usage of SQL Server?
Please Help
TIA
Decreasing the aount of memory that SQL Server uses is counterproductive. If SQL Server is taking 2GB of RAM, then it needs it to support the requirements of your applications. If the server is becoming slow, it is due to other applications running on the server, or if SQL Server is the only application running, you have other issues with your existing datadase(s) on the server. This could include fragmented or out-of-date statistics, improper indexes, etc.
Based on your post, it is difficult to actually tell you what may be the problem.
February 6, 2009 at 6:13 am
Thanks Lynn Pettis
Can you pleae tell how much is the normal CPU and memory utilisation of SQL Server if the RAM is 4GB.
(like it requires minimum of 30% CPU and 1GB RAM)
TIA
February 6, 2009 at 6:21 am
Ratheesh.K.Nair (2/6/2009)
Thanks Lynn PettisCan you pleae tell how much is the normal CPU and memory utilisation of SQL Server if the RAM is 4GB.
(like it requires minimum of 30% CPU and 1GB RAM)
TIA
It all depends on what your system needs to meet the requirements of the application(s) accessing the database(s) on your server. SQL Server will use whatever resources it needs. On your system, based on what you have indicated, the most RAM it will use is 2 GB. I am assuming you are running an x86 (32-bit) version of the OS and SQL Server. As far as CPU, SQL Server could use up to 100% at times depending on what it is doing.
You say it is getting slow. Unfortunately that tells us nothing. What is slow, specific aspects of an application, a specific query, what?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply