From: genew@ocis.net   
      
   On Thu, 07 Apr 2011 23:28:51 +0200, Erland Sommarskog   
    wrote:   
      
   >Gene Wirchenko (genew@ocis.net) writes:   
   >>>Gene Wirchenko (genew@ocis.net) writes:   
   >>>>   1) The odd memory behavour is that SQLSERVR.EXE is taking about   
   >>>> 600MB doing nothing!  Does it ever release memory?  Sure, I was doing   
   >>>> something yesterday.   
   >>>...   
   >>   
   >>      The problem with this is that in this case, its usage pushed   
   >> memory use over the amount of my system's physical memory, so disk   
   >> ended up being read anyway.   
   >   
   >How much memory do you have in your machine? Less than 600 MB? That's   
   >difficult to believe these days.   
      
        No, 1.5GB.   
      
   >If you want to say that other processes were pushed to disk, I believe   
   >you, but normally SQL Server does not allocates so much memory that it   
   >ends up on disk.   
      
        Yes.  Right now, it has started (with boot) and is taking 45296K,   
   but I have not used it yet.  Dare I give it the opportunity to get   
   greedy?   
      
        This may end up being irrelevant shortly.  I am getting a new   
   system now so I can run SQL Server 2011, oops, I mean SQL Server   
   codenamed Denali.  (It is amusing reading that on a Web page written   
   as if it were a real product name.)  I am still going to have to keep   
   using SSE 2008 at least for testing since the company I work for will   
   be dragged off XP kicking and screaming.  I share their sentiments,   
   but I am going to be doing technical review on a book on SS Denali.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)