MEM usage continue to increase

When start SQL Server the MEM usage continue to increase
even when activity is low. How do I solve this problem?
The physical memory is 2 GB and after a few hours the
usage goes to 1.8 GB causing not able the connect with
ODBC error in the front end MSACCESS db.
If you wish to limit the amount of memory that SQL Server uses, run SQL
Enterprise Manager , right click your server and go to the memory tab...
There will be a slider where you can set the maximum memory SQL will use..
Be aware that SQL will NOT release the memory unless there is memory
pressure. This is the way SQL is designed to work. It prevents SQL Server
from wasting resources releasing memory when there is no need to do so.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"norbert" <anonymous@.discussions.microsoft.com> wrote in message
news:269b401c4635a$93ffae30$a601280a@.phx.gbl...
> When start SQL Server the MEM usage continue to increase
> even when activity is low. How do I solve this problem?
> The physical memory is 2 GB and after a few hours the
> usage goes to 1.8 GB causing not able the connect with
> ODBC error in the front end MSACCESS db.
>
|||Have a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default...;en-us;q321363
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"norbert" <anonymous@.discussions.microsoft.com> wrote in message
news:269b401c4635a$93ffae30$a601280a@.phx.gbl...
> When start SQL Server the MEM usage continue to increase
> even when activity is low. How do I solve this problem?
> The physical memory is 2 GB and after a few hours the
> usage goes to 1.8 GB causing not able the connect with
> ODBC error in the front end MSACCESS db.
>