Very RAM usage for SQL Server 2000
-
I need ideas on why I have a very high (70%) RAM usage for my SQL server 2000.Have 3/4 of a Gig of RAM.
Have one intel PIII 500 MHz processor.
Plenty of available disk space.
Thanks!
-
I have. Nothing out of the ordinary as far as I can tell. While in task manager -> i look at the momory usage for applications and SQL is by far the most intensive at 602+ MB of my 768 MB of RAM.
[/quote]
-
There are only 20-30 users connected at any time.
But will take a look a those Alert logs! Thanks
-
Might well be something else, but honestly 3/4 gig aint a lot these days. Heck, I run 512m in my workstations at home! Nothing wrong with it utilizing 70% or more memory, what else would you do with it?
Andy
-
SQL loves memory, we have various servers with various memory, on our gig machine it site 70-80% RAM most of the time. It dynamically allocates the memory by default and tries not to share unless needs to. Also a lot of the caching that helps speed DB access is done in memory. In basic words though it's is normal.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
-
So I should continue to let SQL allocate the memory?
It just appears that retrieving the data is very slow. So the users say.
-
Yes. Then you have to find out why the queries are slow. Might need better indexes, or rebuild the indexes, or tune the queries to be faster or return less data. Ultimately could be a hardware issue, you might need more!
Andy
-
Yeah, I am thinking it's hardware! I am ordering a new server with dual GHz processors and 2GB RAM.
I have some clustered indexes and have defraged the indexes in the databases. Have seen very little performance increase.
Colin
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply