SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Potential SQL 2012 Memory Leak
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sjohnson4532
Starting Member

4 Posts

Posted - 05/13/2014 :  13:37:01  Show Profile  Reply with Quote
I am running SQL 2012 on Windows Server 2008. I have set the maximum allowed memory for SQL Server. Also, I've installed all of the latest SQL 2012 updates.

I have noticed that in task manager that the physical memory in use for the entire server is very slowly growing over time by approximately 1% a week. The SQL Server memory usage in task manager does not appear to be growing but I suspect that this is not accurate. Meaning, I believe that this process is leaking memory that is not able to be tracked by Task Manager.

Has anyone else encountered this issue? Are scheduled reboots an expected practice these days? Is Windows Server 2012 any better?

Any help is much appreciated.

tkizer
Almighty SQL Goddess

USA
37167 Posts

Posted - 05/13/2014 :  13:45:58  Show Profile  Visit tkizer's Homepage  Reply with Quote
SQL Server is a memory hog and will eventually use the maximum allowed memory. This is normal and not a memory leak. Task Manager does not properly display the SQL Server memory consumption but PerfMon does. It's the Total Server Memory counter object in the Memory Manager counter.

There is no reason to schedule a reboot or restart of the service.

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

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 05/19/2014 :  01:49:28  Show Profile  Visit jackv's Homepage  Reply with Quote
Use the sys.dm_os_process_memory DMV rather than Task Manager, for SQL Server memory usage number. Use the query in this post http://www.sqlserver-dba.com/2013/05/task-manager-not-showing-correct-sql-server-memory-usage.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000