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 2012 Forums
 SQL Server Administration (2012)
 SQL SERVER MEMORY SLOWLY REACHING TO HIGH

Author  Topic 

pushpak
Starting Member

2 Posts

Posted - 2014-03-19 : 07:48:57
Hi Friends,

I am facing a issue, since couple of days.
Sql server memory is slowly consuming all memory of server. And when it reaches to max limit, my applications hosted on server gets slow and stops working.

SQL Server is having 65 GB RAM

Min Limit set to 0, and Max limit set to 40GM, in sql server configuration.

I also scheduled to execute following scripts , in sql server agent.

CHECKPOINT
DBCC DROPCLEANBUFFERS

DBCC FREESESSIONCACHE

DBCC FREEPROCCACHE

DBCC FREESYSTEMCACHE('All')

I also tried -

EXEC sp_configure 'show advanced option', '1';

I tried to analyze memory consumption, using various scripts,
but not getting where to hit the issue..

Can anyone pls suggest on the same?

Thnx

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-03-19 : 12:53:20
This is normal. SQL Server is a memory hog. Whatever value you set for its max, SQL Server will use all of it. This is why nothing else should be on the database server, especially things like IIS. Move your other applications to their own box.

Remove that Agent job. It doesn't serve any purpose unless you are trying to get around a parameter sniffing issue or similar, but I would try other methods first such as a plan guide.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

pushpak
Starting Member

2 Posts

Posted - 2014-03-20 : 02:27:24
Thnx Tara.

I had disabled the job.

Let me check plan guide
Go to Top of Page
   

- Advertisement -