|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Dynamic Ram allocation..?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Dynamic Ram allocation..?
|
|
| Kent Johnson 2002-11-20, 3:23 pm |
| Hi all,
I have a SQL2000 server with max 700 meg ram allocated to the server.
The SQL2000 is supposed to dynamically use up to 700 meg depeding of what is
needed.
In order to free the Ram to other applications (Cognos PowerPlay) I have to
start and stop the SQL-service manually.
Question:
1.) Do I really need to stop and start the SQL-service? Is there a better
way?
2.) If I have to stop and start how should the syntax be in a command file?
/Kent J.
| |
| Keith Kratochvil 2002-11-20, 4:23 pm |
| (1) no. SQL Server shoudl release memory if other apps on that box need it.
(2) I would REALLY, REALLY recommend against this, but you could use
NET STOP
and
NET START
to stop and start the services within a batch file.
USE WITH CAUTION! You might want to make sure that you do not pull the rug
out from any users who may be connected to the database and doing some work
--
Keith, SQL Server MVP
"Kent Johnson" <kent.johnson@telia.com> wrote in message
news:MPSC9.82$NS2.3828@newsb.telia.net...
> Hi all,
>
> I have a SQL2000 server with max 700 meg ram allocated to the server.
> The SQL2000 is supposed to dynamically use up to 700 meg depeding of what
is
> needed.
>
> In order to free the Ram to other applications (Cognos PowerPlay) I have
to
> start and stop the SQL-service manually.
>
> Question:
> 1.) Do I really need to stop and start the SQL-service? Is there a better
> way?
> 2.) If I have to stop and start how should the syntax be in a command
file?
>
>
> /Kent J.
>
>
| |
| Tibor Karaszi 2002-11-21, 5:23 am |
| .... and consider also specifying max server memory using sp_configure. (Although I agree with
Keith's point 1.)
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Keith Kratochvil" <keith.kratochvil.back2u@novusprintmedia.com> wrote in message
news:ejaETsNkCHA.2156@tkmsftngp12...
> (1) no. SQL Server shoudl release memory if other apps on that box need it.
> (2) I would REALLY, REALLY recommend against this, but you could use
> NET STOP
> and
> NET START
> to stop and start the services within a batch file.
>
> USE WITH CAUTION! You might want to make sure that you do not pull the rug
> out from any users who may be connected to the database and doing some work
>
>
> --
> Keith, SQL Server MVP
>
>
> "Kent Johnson" <kent.johnson@telia.com> wrote in message
> news:MPSC9.82$NS2.3828@newsb.telia.net...
> > Hi all,
> >
> > I have a SQL2000 server with max 700 meg ram allocated to the server.
> > The SQL2000 is supposed to dynamically use up to 700 meg depeding of what
> is
> > needed.
> >
> > In order to free the Ram to other applications (Cognos PowerPlay) I have
> to
> > start and stop the SQL-service manually.
> >
> > Question:
> > 1.) Do I really need to stop and start the SQL-service? Is there a better
> > way?
> > 2.) If I have to stop and start how should the syntax be in a command
> file?
> >
> >
> > /Kent J.
> >
> >
>
>
|
|
|
|
|