August 11, 2008 at 10:37 am
Hi Expert,
Anybody knows, why sql server 2005 consume all of memory on server?
previous, our server using 2Giga physical memory...and sql server used at 1.8Giga (normal situation , not peak hour..if at peak hour it can over than physical memory )
by the way we upgraded our memory to 4Giga Physical memory....and sql server again consume memory at 3.8Giga (normal situation, not peak hour)
if we upgrade again to 6Giga..can it consume again at 5.8Giga?
Any Idea or suggestion??
i've done 'dbcc freecache' bla..bla...but no affect 🙁
August 11, 2008 at 10:40 am
I'm assuming you mean gigabytes, not gigahertz, for your amount of memory.
There's a setting in your server options for maximum (and minimum) memory. You need to make sure that's set correctly. Right-click on the server in Management Studio, go to Properties, then the Memory branch.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 11, 2008 at 10:46 am
Can it make low performance?
August 11, 2008 at 12:12 pm
SQL Server uses as much memory as it needs or that is available. It caches database data pages for performance reasons. Unless you are having a problem with the server or other applications on the server I would leave the memory settings alone and do some research first.
Google sql server memory management and you will get several quality hits.
Wes
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply