|
Home > Archive > MS SQL Server > February 2006 > SQL Server 2005 Express Memory usage
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2005 Express Memory usage
|
|
| Martin 2006-02-12, 8:23 pm |
| I have added 1GB of RAM to my workstation, bring the total to 1.5GB.
When Express is running, Task manager shows 760MB in use with 1.5MB
available. The usage is close to what it was before the upgrade.
How do I persuade Express to use its maximum of 1GB?
Thanks
Martin
| |
| David Gugick 2006-02-12, 8:23 pm |
| Martin wrote:
> I have added 1GB of RAM to my workstation, bring the total to 1.5GB.
> When Express is running, Task manager shows 760MB in use with 1.5MB
> available. The usage is close to what it was before the upgrade.
>
> How do I persuade Express to use its maximum of 1GB?
>
> Thanks
>
> Martin
It will, if it needs to. Apparently, either it only wants to use 760MB or
your OS has other services running that are chewing up the additional RAM.
It is designed to use up to 1GB of RAM. You can force SQL Server to use 1GB
at startup (although it might not really need it) by setting the min/maximum
server memory settings to the same value. See sp_configure and "server
memory options" in BOL for more information - or you can do this from SQLMS
under the properties for the server (memory settings).
http://www.microsoft.com/sql/prodin...e-features.mspx
--
David Gugick - SQL Server MVP
Quest Software
| |
| Martin 2006-02-16, 11:23 am |
| Thank you David.
Martin
David Gugick wrote:
> Martin wrote:
>
> It will, if it needs to. Apparently, either it only wants to use 760MB or
> your OS has other services running that are chewing up the additional RAM.
> It is designed to use up to 1GB of RAM. You can force SQL Server to use 1GB
> at startup (although it might not really need it) by setting the min/maximum
> server memory settings to the same value. See sp_configure and "server
> memory options" in BOL for more information - or you can do this from SQLMS
> under the properties for the server (memory settings).
>
> http://www.microsoft.com/sql/prodin...e-features.mspx
>
>
> --
> David Gugick - SQL Server MVP
> Quest Software
|
|
|
|
|