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 2008 Forums
 SQL Server Administration (2008)
 High Memory utilization

Author  Topic 

DBA007
Posting Yak Master

145 Posts

Posted - 2013-06-10 : 05:01:47
Hi Everyone,
One of our server in the production environment is hitting 93% of memory utilization and sqlserver is the only one installed in the server and takes almost 7gb out of total 8gb memory.
we haven't configured any min and max settings as sqlserver is the only one installed.
Does any one have faced these kind of issues,Please provide the steps for troubleshooting.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-06-10 : 08:15:29
SQL Server will indeed consume as much memory as it is allowed to, without regards to whether it is going to starve other applications and Windows OS of needed memory. To avoid that, you need to set the maximum memory that SQL Server is allowed to consume. You can set this from SSMS by right-clicking on the server, selecting Properties -> Memory tab. Set the maximum server memory to be what you want to allow SQL Server to use.

Remember that it is to be specified in MEGABYTES. In your case, I would set it about 6000 MB, leaving 2GB for the Windows OS.

This is a safe operation to do on production servers; the memory consumed by SQL Server may not come down immediately, but it eventually will.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-06-10 : 14:21:32
As well as suggestion made bt @James K , some other considerations
1) Task Manager does not always show the memory usage accurately - read more http://www.sqlserver-dba.com/2013/05/task-manager-not-showing-correct-sql-server-memory-usage.html
2) Once you've configured system as expected - analyse memory usage - http://www.sqlserver-dba.com/2012/09/sql-server-measuring-sql-memory-usage.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -