Hi,
After some time, my server Memory Usage History run up to 80%-90% even the
server does not have any connection in it.
This is server running only MS SQL 2000 + IIS in Win2K Server.
I was wondering that, by using the Win / WMI command to refresh / reset
this Memory Usage History.
Does anyone try this before or any ideal from you all?
Thank you.....
--
Regard,
Kzeto ngHave a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Kzeto ng" <kzetong@.yahoo.com> wrote in message news:eVe2I3kuDHA.3196@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After some time, my server Memory Usage History run up to 80%-90% even the
> server does not have any connection in it.
> This is server running only MS SQL 2000 + IIS in Win2K Server.
> I was wondering that, by using the Win / WMI command to refresh / reset
> this Memory Usage History.
> Does anyone try this before or any ideal from you all?
> Thank you.....
> --
> Regard,
> Kzeto ng
>
>|||How much memory do you have, how much is assigned to SQL (see SQL
configuration parameters)?
And how much is the threshold set for IIS (check your machine.config file)?
Willy.
"Kzeto ng" <kzetong@.yahoo.com> wrote in message
news:eVe2I3kuDHA.3196@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After some time, my server Memory Usage History run up to 80%-90% even
the
> server does not have any connection in it.
> This is server running only MS SQL 2000 + IIS in Win2K Server.
> I was wondering that, by using the Win / WMI command to refresh / reset
> this Memory Usage History.
> Does anyone try this before or any ideal from you all?
> Thank you.....
> --
> Regard,
> Kzeto ng
>
>
Showing posts with label usage. Show all posts
Showing posts with label usage. Show all posts
Subscribe to:
Posts (Atom)