I have an instnace of Sql-Server 2005 64-bit running on Windows Server 2003 R2 Standard x64 SP2. The box has 8 gigs Ram.
For the Memory options in sql-server I have Minimum 128 MB and max 2147483647 MB.
However, Task Manager *always* shows around 7.8 GB on the Performance tab, under PF Usage (This tab, I've found from previous posts I've made, has some extremely counter-intuitive wording for these graphs and memory information, but I've been able to gleen that this is basically the amount of memory in use).
Also, the "Physical Memory" numbers show:
System Cache: 554,092
This box, for all intents and purposes, is totally dedicated to sql-server, there are no other non-OS processes that run on this. These numbers are essentially stagnant whether the server is being pounded with huge loads and when it's completely idle with essentially no db connections.
But in the "Processes" tab it only says 187,296 K for sqlservr.exe.
So my question is how can that much memory can be "off the books", or "stealth processes"?
It just makes me nervous that so much memory can be used up and hidden from any sort of accountability. For things from viruses to errant programs, I've always sort of depended upon Task Manager to show me what the heck is taking up memory. But I've lost trust in that now that I see that so much memory can be taken up and Task Manager can't even account for it.
My reasonable assumption is that it's Sql-server that's using this memory, but with the minimums set the way they are why doesn't it do one of two things:
A. Release the memory
B. Show the memory usage in Task Manager's Processes tab, showing the process using (or at least reserving) that huge chunk.