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.
| 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 RAMMin 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
pushpak
Starting Member
2 Posts |
Posted - 2014-03-20 : 02:27:24
|
| Thnx Tara.I had disabled the job.Let me check plan guide |
|
|
|
|
|
|
SQL SERVER MEMORY SLOWLY REACHING TO HIGH