Re: [Emerald] SQL 7.0 keeps eating memory

NCKCN ( (no email) )
Mon, 22 May 2000 11:14:53 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_00A3_01BFC3DE.F43E68B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Any particular things that I should set up with PerfMon to look at the =
memory usage? There's a whole slug of SQL server options to monitor.

-----------------------------------------------------------------
Thanks,
TKT
-----------------------------------------------------------------
----- Original Message -----=20
From: Brian=20
To: emerald@iea-software.com=20
Sent: Monday, May 22, 2000 10:54 AM
Subject: Re: [Emerald] SQL 7.0 keeps eating memory

NCKCN wrote:=20
That's another weird thing. I show absolutely no errors of any kind. =
I have=20
checked the NT Logs as well as the SQL logs. All appear normal. =
There are=20
random transaction rollbacks or rollforwards that usually have 0 =
updates.=20
But there is nothing that indicates any processes hung etc. Can I =
set up=20
PerfMon to look at things? And will it tell me anything anyway?=20
-----------------------------------------------------------------=20
Thanks,=20
TKT=20
-----------------------------------------------------------------=20
=20
=20

Perfmon is a great start. Especially with the SQL options. If you log =
it, it should give you an idea of the time the memory is incrementing. =
It should give you some sort of pattern you can check against your =
Radius logs and SQL logs to see what is going on.=20
--=20

Thanks,=20
Brian Dooley=20
Classic Service=20
http://www.cserv.net=20

```````````````````````````````````````````````````````````````````=20
- Man cannot survive except by gaining knowledge,=20
and reason is his only means to gain it.-=20

Ayn Rand=20
=20

------=_NextPart_000_00A3_01BFC3DE.F43E68B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Any particular things that I should set =up with=20PerfMon to look at the memory usage? There's a whole slug of SQL server =options=20to monitor.

------------------------------------------------------------=-----
Thanks,
TKT
----------------------------------------------=-------------------
----- Original Message -----
From:=20 Brian
To: emerald@iea-software.com
Sent: Monday, May 22, 2000 =10:54 AM
Subject: Re: [Emerald] SQL 7.0 =keeps=20 eating memory

NCKCN wrote:=20
That's another weird thing. I show =absolutely no=20 errors of any kind. I have
checked the NT Logs as well as the =SQL logs.=20 All appear normal. There are
random transaction rollbacks or=20 rollforwards that usually have 0 updates.
But there is nothing =that=20 indicates any processes hung etc. Can I set up
PerfMon to look =at=20 things? And will it tell me anything anyway?=20

----------------------------------------------------------------- =
Thanks,
TKT=20 =
-----------------------------------------------------------------=20
 
&nbs=p;

Perfmon=20 is a great start. Especially with the SQL options. If you log it, it =should=20 give you an idea of the time the memory is incrementing. It should =give you=20 some sort of pattern you can check against your Radius logs and SQL =logs to=20 see what is going on.=20

--=20

Thanks,
Brian Dooley
Classic Service
http://www.cserv.net=20

``````````````````````````````````````````````````````````````````` =
  - Man cannot survive except by gaining knowledge,=20
    and reason is his only means to gain it.-=20

    Ayn Rand
  =

------=_NextPart_000_00A3_01BFC3DE.F43E68B0--