Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 High Memory usage

Author  Topic 

DBA007
Posting Yak Master

145 Posts

Posted - 2012-08-06 : 01:40:09
Team,

one of our Prod sqlserver is taking 6.5gb memory out of total 8gb of the system.It is 2008R2 64bit standard edition.

I ran memorystatus and found BUFFERPOOL committed and Target values are same which is equal to value=920406

Please provide your inputs for decreasing the sqlserver memory.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-08-06 : 13:10:11
Why do you think it needs to be decreased? What is the max memory value set to?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2012-08-06 : 13:13:28
Why would you want to? This is normal for SQL Server.
Go to Top of Page
   

- Advertisement -