ananda.murugesan (9/11/2012)
Performance Tap in task manager why 7.5 GB consuming physical memory using after restarted SQL services, it was totaly reduced and now comsuming 4.55 GB only...thats what I have mention first post memory leak sql 2k8 r2.
There is no memory leak.
SQL uses as much memory as it needs up to max server memory + a bit for the non-buffer memory. All that the 4.5 GB now tells us is that SQL has only needed 4.5 GB of memory since the restart. Everything you've shown so far shows a SQL Server that's working fine and as expected.
Again, don't use Task Manager to show SQL's memory usage, it shows incorrectly (fault of Task Manager, not SQL Server) if locked pages is enabled.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability