Re: [Emerald] SQL Tasks HELP ASAP

PowerNet ( (no email) )
Thu, 23 Sep 1999 15:00:19 -0400

In SQL perf monitor currently:

Cache Hit Ratio =3D 100
User connection=3D 20ish
All I/O's =3D less than 5


*********** REPLY SEPARATOR ***********

On 9/23/99, at 9:58 AM, Dale E. Reed Jar. wrote:

>PowerNet wrote:
>> Emerald UpdateCalls Accounts
>> I think we have quite a bit of memory allocated to SQL, and until=
yesterday, the task completed in about 11 minutes when it didn't fail.
>> This task fails every other day.
>> Yesterday the task completed in 1 hr and 12 minutes
>> Today it was not finished after 8 hours.
>> Or consolidation has also taken forever in the past 2 days.
>> I am baffled.
>Sounds like something needs a boot. Use EM to see whats running.
>You can also use Perf Mon to track all the different SQL options.
>There is a default Perf Mon link in the SQL Group that is a good
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.
>For more information about this list (including removal) go to:

For more information about this list (including removal) go to: