| Author |
Physical RAM Problem
|
|
| Farhan Iqbal 2005-09-26, 7:23 am |
| I have Enterprise Edition of SQL Server 2000 with 2 GB of physical RAM, this
is in my observation that every day this server uses entire physical RAM and
not releasing it, at last I have to restart the services of my server.
Can any buddy help me in this regards how can I release the memory from the
Server.
--
Regards
Farhan Iqbal
Database Administrator
| |
| Mike Epprecht \(SQL MVP\) 2005-09-26, 7:23 am |
| Hi
That is by design. SQL Server uses the RAM for caching of data.
Read http://support.microsoft.com/defaul...kb;en-us;321363 for more
information.
--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Farhan Iqbal" < mr_farhaniqbal@hotma
il.com> wrote in message
news:%230Q7IynwFHA.2516@TK2MSFTNGP12.phx.gbl...
>I have Enterprise Edition of SQL Server 2000 with 2 GB of physical RAM,
>this
> is in my observation that every day this server uses entire physical RAM
> and
> not releasing it, at last I have to restart the services of my server.
>
>
>
> Can any buddy help me in this regards how can I release the memory from
> the
> Server.
>
>
> --
> Regards
>
> Farhan Iqbal
> Database Administrator
>
>
| |
| Farhan Iqbal 2005-09-26, 7:23 am |
| Thanx for Prompt Reply Mike,
Can u tell me, what effect it will produce if we restarts SQL Services
every day? because we are doing this right now.
what are the factors which make SQL Server eat memory so quickly as this
problem makes our web application too slow to response?
Regards
Farhan Iqbal
Database Administrator
"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:%23v2skbowFHA.2808@TK2MSFTNGP10.phx.gbl...
> Hi
>
> That is by design. SQL Server uses the RAM for caching of data.
>
> Read http://support.microsoft.com/defaul...kb;en-us;321363 for
more
> information.
>
> --
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Farhan Iqbal" < mr_farhaniqbal@hotma
il.com> wrote in message
> news:%230Q7IynwFHA.2516@TK2MSFTNGP12.phx.gbl...
>
>
| |
| Andrew J. Kelly 2005-09-26, 9:23 am |
| Are you running other applications than SQL Server on the same box? If so
you might want to limit the max memory sql server can use so that there is
always memory for other apps and there is not a constant battle for memory.
The most likely cause of too much memory use are unoptimized queries or lack
of proper indexes. If you scan tables instead of seeks you can eat up lots
of memory fast.
--
Andrew J. Kelly SQL MVP
"Farhan Iqbal" < mr_farhaniqbal@hotma
il.com> wrote in message
news:OtnMxkowFHA.3864@TK2MSFTNGP12.phx.gbl...
> Thanx for Prompt Reply Mike,
>
> Can u tell me, what effect it will produce if we restarts SQL Services
> every day? because we are doing this right now.
> what are the factors which make SQL Server eat memory so quickly as this
> problem makes our web application too slow to response?
>
> Regards
>
> Farhan Iqbal
> Database Administrator
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:%23v2skbowFHA.2808@TK2MSFTNGP10.phx.gbl...
> more
>
>
| |
| Farhan Iqbal 2005-09-26, 9:23 am |
| No, we are using dedicated SQL Server no other application is running on
this server.
will installing SP4 help us in this regards we have SP3a.
--
Regards
Farhan Iqbal
Database Administrator
"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:OgjvCspwFHA.2880@TK2MSFTNGP12.phx.gbl...
> Are you running other applications than SQL Server on the same box? If
so
> you might want to limit the max memory sql server can use so that there is
> always memory for other apps and there is not a constant battle for
memory.
> The most likely cause of too much memory use are unoptimized queries or
lack
> of proper indexes. If you scan tables instead of seeks you can eat up
lots
> of memory fast.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Farhan Iqbal" < mr_farhaniqbal@hotma
il.com> wrote in message
> news:OtnMxkowFHA.3864@TK2MSFTNGP12.phx.gbl...
RAM,[color=darkred]
server.[color=darkred]
from[color=darkred]
>
>
| |
| Andrew J. Kelly 2005-09-26, 11:23 am |
| If SQL Server is the only thing running on that server the memory usage
should not be an issue. SQL Server will always leave some for the OS and
give some back if it needs more. Unless you are doing some thing that is
causing a memory leak this should not be a problem. Are you sure your issues
are related to memory usage? Rebooting can mask a lot of things.
--
Andrew J. Kelly SQL MVP
"Farhan Iqbal" < mr_farhaniqbal@hotma
il.com> wrote in message
news:ehh1IDqwFHA.2516@TK2MSFTNGP12.phx.gbl...
> No, we are using dedicated SQL Server no other application is running on
> this server.
>
> will installing SP4 help us in this regards we have SP3a.
> --
> Regards
>
> Farhan Iqbal
> Database Administrator
>
>
> "Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
> news:OgjvCspwFHA.2880@TK2MSFTNGP12.phx.gbl...
> so
> memory.
> lack
> lots
> RAM,
> server.
> from
>
>
| |
| Farhan Iqbal 2005-09-26, 11:23 am |
| Thanx Andrew,
No, I am not sure about this but this is being inforce on me.
tell me what other factors I have to check, we are not running any other
things on this server.
Should I install SP4 on my server I have SP3a
--
Regards
Farhan Iqbal
Database Administrator
"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:uuom9kqwFHA.212@TK2MSFTNGP12.phx.gbl...
> If SQL Server is the only thing running on that server the memory usage
> should not be an issue. SQL Server will always leave some for the OS and
> give some back if it needs more. Unless you are doing some thing that is
> causing a memory leak this should not be a problem. Are you sure your
issues
> are related to memory usage? Rebooting can mask a lot of things.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Farhan Iqbal" < mr_farhaniqbal@hotma
il.com> wrote in message
> news:ehh1IDqwFHA.2516@TK2MSFTNGP12.phx.gbl...
If[color=darkred]
Services[color=darkr
ed]
physical[color=darkr
ed]
>
>
| |
|
|
|
|