------=_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">
------=_NextPart_000_00A3_01BFC3DE.F43E68B0------- Original Message -----From:=20 BrianSent: Monday, May 22, 2000 =10:54 AMSubject: Re: [Emerald] SQL 7.0 =keeps=20 eating memoryNCKCN wrote:=20That's another weird thing. I show =absolutely no=20 errors of any kind. I havePerfmon=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
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;--=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.-=20Ayn Rand
=