Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #145

Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour

Show all headers | View raw

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.

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.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

SQL Server 2008 Express: Odd Memory and Disk Behaviour Gene Wirchenko <genew@ocis.net> - 2011-04-06 17:06 -0700
  Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour Erland Sommarskog <esquel@sommarskog.se> - 2011-04-07 08:21 +0000
    Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour Gene Wirchenko <genew@ocis.net> - 2011-04-07 13:08 -0700
      Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour Erland Sommarskog <esquel@sommarskog.se> - 2011-04-07 23:28 +0200
        Re: SQL Server 2008 Express: Odd Memory and Disk Behaviour Gene Wirchenko <genew@ocis.net> - 2011-04-07 18:15 -0700

csiph-web