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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

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.

Almighty SQL Goddess

38200 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
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2179 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

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next 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.02 seconds. Powered By: Snitz Forums 2000