Memory

Hi,
How do i calculate de right memory for my MSSQL Server 2000, is there
any formula?
Thanks
Luis FoutoWhat edition of SQL Server do you have? What is your operating system?
SQL Server Standard Edition running on Win2k Standard can use a max of 2GB
of RAM.
How big are your databases?
What other applications (or services such as IIS) are running on the server?
Generally you want to allow SQL Server to use as much memory as it needs.
If you have other apps running and limited memory you may want to limit
memory usage somewhat.
--
Keith
"Luis Fouto" <luis.fouto@.highvalue.pt> wrote in message
news:uSZh2IDvEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How do i calculate de right memory for my MSSQL Server 2000, is there
> any formula?
> Thanks
> Luis Fouto
>|||The Book SQL Server 2000 Administrators Companion has a
rough guide formula for the amount memory to be used by
SQL Server which goes something like
(500K * The Number of Users) + (Database prcoess memory)
The data process memory is to do with the data and log
cache sizes although unless you know a lot more on what
your going to have on it is going to be a bit hard to
calculate.
Personally I would do as Keith sugested, get as much of it
as you can, but remember stealing it is again the law in
most counties.
Peter
"Adam and Eve had many advantages but the principal one
was that they escaped teething."
Mark Twain
>--Original Message--
>Hi,
> How do i calculate de right memory for my MSSQL
Server 2000, is there
>any formula?
>Thanks
>Luis Fouto
>
>.
>