Re: [Emerald] SQL 7.0 keeps eating memory

Brian ( support@cserv.net )
Mon, 22 May 2000 11:54:00 -0400

--------------3EBF244B943D9757C8ED8B75
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

NCKCN wrote:

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

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.

--

Thanks,Brian DooleyClassic Servicehttp://www.cserv.net

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

    Ayn Rand



--------------3EBF244B943D9757C8ED8B75Content-Type: text/html; charset=us-asciiContent-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">NCKCN wrote:
That's another weird thing. I show absolutely noerrors of any kind. I have
checked the NT Logs as well as the SQL logs. All appear normal. Thereare
random transaction rollbacks or rollforwards that usually have 0 updates.
But there is nothing that indicates any processes hung etc. Can I setup
PerfMon to look at things? And will it tell me anything anyway?
-----------------------------------------------------------------
Thanks,
TKT
-----------------------------------------------------------------
 
 
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 shouldgive you some sort of pattern you can check against your Radius logs andSQL logs to see what is going on.
--
Thanks,
Brian Dooley
Classic Service
http://www.cserv.net
```````````````````````````````````````````````````````````````````
  - Man cannot survive except by gaining knowledge,
    and reason is his only means to gain it.-
    Ayn Rand
 --------------3EBF244B943D9757C8ED8B75--