From: "Info" <info@olynet.com> Subject: RE: [Emerald] 100% CPU Usage Date: Fri, 2 Feb 2001 10:11:19 -0800 Message-ID: <A6FE4BB028E3D311A19900A0C949C6EB1EB5E0@250.olynet.com>
I have noticed that when the Transaction logs fill the DB that sometimes SQL
has a hard time growing. We have seen SQL take 24 hours to recover when
this happens. Not very often though. Have you tried rebooting yet? Also
you might want to consider reapplying the SP. It could just be a memory
leak and a NT resource thing.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Terence
Sent: Friday, February 02, 2001 10:14 AM
To: emerald@iea-software.com
Subject: Re: [Emerald] 100% CPU Usage
We are running SQL 7.0 SP1. Yes we have it set for automatic expansion.
----- Original Message -----
From: Info <info@olynet.com>
To: <emerald@iea-software.com>
Sent: Friday, February 02, 2001 8:56 PM
Subject: RE: [Emerald] 100% CPU Usage
> What SQL are you running? 6.5 or 7.0? Also do you have it set to
> automatically expand the database once it is full?
>
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Terence
> Sent: Friday, February 02, 2001 10:07 AM
> To: emerald@iea-software.com
> Subject: [Emerald] 100% CPU Usage
>
>
> Our SQL/Emerald server has become extremely slow and is using 100% of the
> CPU , I also see continous hard disk activity. On emerald, the calls
online
> view is not showing any new users. I have re-booted the machine a couple
of
> times, it comes up OK but immediately goes into the above cycle.
>
> Does anyone have any idea what could be causing this ? Does SQL run any
> maintenance routines by itself ?
>
> Any ideas will be much appreciated.
>
> Terence
>
> ------------
>
> This is a user supported list. If you require assistance from IEA
Software's
> Support Engineers, please check out our Support resources at
> http://www.iea-software.com/support.
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
> ------------
>
> This is a user supported list. If you require assistance from IEA
Software's
> Support Engineers, please check out our Support resources at
> http://www.iea-software.com/support.
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
------------
This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at
http://www.iea-software.com/support.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart
.