Refresh Memory Usage History in Taskman

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

Referenced Memory Problem with Enterprise Manager

When I attempt to attach a database using the wizard in the manager, I get
the following error when I click on the button to select MDF file of
database to attach:
The instruction at "0x41d53c0a" referenced memory at "0xffffffff". The
memory could not be read.
I've reinstalled SQL SP3a and Windows 2003 patches. Is this error a result
of a memory hardware problem or a conflict with another installed
application?
How can I resolve the problem since I am unable to use the manager for this
function?
thanks.Could me several issues. Could be a bad SQL Server binary. Mismatched
MDAC. Bad MMC build. Or, your worst fears, the .MDF file may be locked or
corrupt.
I'd try to attach to another SS server and/or use Query Analyzer and
sp_attach_db to narrow down if it is the .MDF file the local SS installation
or just the SQL EM tool.
Sincerely,
Anthony Thomas
"Dan Slaby" <dslaby3@.comcast.net> wrote in message
news:eq6sX9WAFHA.2180@.TK2MSFTNGP10.phx.gbl...
When I attempt to attach a database using the wizard in the manager, I get
the following error when I click on the button to select MDF file of
database to attach:
The instruction at "0x41d53c0a" referenced memory at "0xffffffff". The
memory could not be read.
I've reinstalled SQL SP3a and Windows 2003 patches. Is this error a result
of a memory hardware problem or a conflict with another installed
application?
How can I resolve the problem since I am unable to use the manager for this
function?
thanks.|||I resolved the problem by making another install of SP3a.
"Dan Slaby" <dslaby3@.comcast.net> wrote in message
news:eq6sX9WAFHA.2180@.TK2MSFTNGP10.phx.gbl...
> When I attempt to attach a database using the wizard in the manager, I get
> the following error when I click on the button to select MDF file of
> database to attach:
> The instruction at "0x41d53c0a" referenced memory at "0xffffffff". The
> memory could not be read.
> I've reinstalled SQL SP3a and Windows 2003 patches. Is this error a result
> of a memory hardware problem or a conflict with another installed
> application?
> How can I resolve the problem since I am unable to use the manager for
> this function?
> thanks.
>
>