memory

[Shawn]

We add RAM to a Cluster server SQL 2000 box.

I need to re-configure the SQL Server memeory.

What is the best pratice? Do I have to shutdown, sp_configure... what
about cache memory? Please clear me.

Is this process for Sybase 12.5 is same? In Unix env?

Thanks

[Simon Hayes]

Re: memory

farzan_toronto1 01@yahoo.com (Shawn) wrote in message news:<ab561c63. 0408172052.5f06 2186@posting.go ogle.com>...[color=blue]
> We add RAM to a Cluster server SQL 2000 box.
>
> I need to re-configure the SQL Server memeory.
>
> What is the best pratice? Do I have to shutdown, sp_configure... what
> about cache memory? Please clear me.
>
> Is this process for Sybase 12.5 is same? In Unix env?
>
> Thanks[/color]

If you add RAM, and MSSQL is dynamically managing its own memory, then
you shouldn't have to do anything - it will use the extra memory
automatically. If you are manually configuring the memory, then you
will have to use sp_configure (or Enterprise Manager) to set the new
settings you want, then restart MSSQL.

If you're adding more than 2GB of memory, this KB article might be
useful:

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&Product=sql2k

If this doesn't answer your question, you should post some more
details so that someone can give a better suggestion. What version of
Windows you have (2000, 2003, Server, Advanced Server etc), what
edition of MSSQL (Standard, Enterprise), how much RAM you have now,
how much RAM you are going to add, and how you have configured the
memory currently (does MSSQL manage it automatically, or have you
fixed values for it to use).

Simon