Re: [Emerald] SQL Tasks HELP ASAP

Dale E. Reed Jr. ( (no email) )
Thu, 23 Sep 1999 09:58:26 -0700

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
starter.

-- 

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart