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
>sql