i have a SQL 2005 box - it is running windows 2003 standard with sp2 on it.
My SQL 2005 has SP2 and CU 9 running on it. Version ID is 9.00.3820.00
My problem is this - I look in my process monitor and I see 2gb of physical ram being used but when I check the processes there is no way it is near that.
When I restart SQL bang it all comes back.
Is this normal? and if not can I do something to fix it. I hate not knowing what is taking my ram.