Friday, July 20, 2012

SQL Server 2008 – High Memory Utilization / Memory Leak / Not releasing Memory

I have been working with SQL 2000 and since that knowing that SQL server ill use and release memory depending on its requirement and unitization.  This is not true with SQL 2008 while it is installed on Windows server 2008.
SQL 2008 will utilize as much memory assign to SQL Server while high resource oriented task running. It will never releasing this memory back to system though task finish. If any other task needed memory SQL internally flush out the older data from the memory. To release memory reserved by SQL 2008 you need to re-start SQL services. 
I also observed sometime in task manager also assigned memory not showing against the SQL Server.

No comments:

Post a Comment