November 22, 2012 at 2:34 am
Hi Friends,
In my sql server 2008 server having 80gb ram.some time its utilizing more than 65 gb.
What might be the cause and how to fix it ? pls provide docs or your suggestion.as i am new in sql server.
Waiting for earliest reply .
Thanks in advance
Regards
November 22, 2012 at 2:39 am
Server with 80GB of RAM and SQL using 65GB of RAM is not a problem if the server is dedicated to SQL only.
I would strongly recommend setting a max limit of around 75GB so that SQL will not go over that limit and starve the OS.
Take a look in my signature for the Accidental DBA guide, it has a whole chapter on Memory Management.
November 22, 2012 at 2:40 am
High CPU or high memory? High memory is normal and good, it's not a problem.
High CPU, see chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
also
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply