SQL Server not releasing Memory
- by noob2487
I am using SQL Server 2005.
I am running a job which processes around 100 K records. Job runs fine, it takes are 45 mins to execute, which is good.
But after that job is processed, I can see instance of SQL Server 2005 still there with around 900 MB of Memory. I waited for around 2 hrs but that memory was not released.
Is there any process which takes care of memory here, something like GC (unpredictable) Or am I doing something wrong???