How much memory is safe to reserve for SQL?

I am running SQL 2000 in a Windows Server 2000. The server only has 1.5
Gb of RAM. One of the databases is taking 1GB of space and it has 8
connections running at all times. I want to limit the amount of memory
that SQL uses, beucase SQLSVR.EXE is taking 1+ Gb of the memory of the
server. How much memory is advise to let SQL use in this case? 50%, 60%
of the total memory of the server?Hi,
If the server is dedicated for SQL Server then I will go with dynamic memory
allocation. If you have any other application running in the same server
apart from SQL Server then probably limit the SQL Server memort by 1 GB or
so...
Thanks
Hari
SQL Server MVP
"WR" <wilsonrey@.gmail.com> wrote in message
news:1156132604.617900.25730@.h48g2000cwc.googlegroups.com...
>I am running SQL 2000 in a Windows Server 2000. The server only has 1.5
> Gb of RAM. One of the databases is taking 1GB of space and it has 8
> connections running at all times. I want to limit the amount of memory
> that SQL uses, beucase SQLSVR.EXE is taking 1+ Gb of the memory of the
> server. How much memory is advise to let SQL use in this case? 50%, 60%
> of the total memory of the server?
>|||Thank you for your advise. The server actually runs a point of sale
system and some customize software too. My concern is that the memory
usage is always high, generally running at 70 of the memory. I read
that SQL is not very good releasing memory after a service runs, and
that it will only release it when a programa needs it. I don't want to
wait until Windows sends a low memory warning for SQL release the
memory.
If you recommend 1 GB, then my next question is: Can the SQL server
service be reprogram to restart one a day in the middle of the day? so,
it will release the memory that is hugging?
WR wrote:
> I am running SQL 2000 in a Windows Server 2000. The server only has 1.5
> Gb of RAM. One of the databases is taking 1GB of space and it has 8
> connections running at all times. I want to limit the amount of memory
> that SQL uses, beucase SQLSVR.EXE is taking 1+ Gb of the memory of the
> server. How much memory is advise to let SQL use in this case? 50%, 60%
> of the total memory of the server?|||Hi,
Why do you want an outage in the middle of the day. Let SQL Server takes 1
GB RAM and use it for its own purpose.
The rest of the memory will be used for operating system and other
applications.You do not require a service restart.
Incase if you are experiancing slow performance; try monitoring the using
the memory related counters
mentioned in below URL.
[url]http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp[
/url]
Thanks
Hari
SQL Server MVP
"WR" <wilsonrey@.gmail.com> wrote in message
news:1156167157.496825.260490@.h48g2000cwc.googlegroups.com...
> Thank you for your advise. The server actually runs a point of sale
> system and some customize software too. My concern is that the memory
> usage is always high, generally running at 70 of the memory. I read
> that SQL is not very good releasing memory after a service runs, and
> that it will only release it when a programa needs it. I don't want to
> wait until Windows sends a low memory warning for SQL release the
> memory.
> If you recommend 1 GB, then my next question is: Can the SQL server
> service be reprogram to restart one a day in the middle of the day? so,
> it will release the memory that is hugging?
>
> WR wrote:
>|||Hello,
Thank you again for your information. I gets I was having too much
cafeine that day before I sent the email. What I meant to say what to
restart SQL once a day in the middle of the night.
Any way, I will follow your advise to your advise and monitor the
memory, still I would like to be able to not to have SQL taking all
that memory at all times. (I know, I am hard head) ;-)
Hari Prasad wrote:[vbcol=seagreen]
> Hi,
> Why do you want an outage in the middle of the day. Let SQL Server takes 1
> GB RAM and use it for its own purpose.
> The rest of the memory will be used for operating system and other
> applications.You do not require a service restart.
> Incase if you are experiancing slow performance; try monitoring the using
> the memory related counters
> mentioned in below URL.
> http://www.sql-server-performance.c...ver.as
p
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "WR" <wilsonrey@.gmail.com> wrote in message
> news:1156167157.496825.260490@.h48g2000cwc.googlegroups.com...sql