Cache Hit Ratio =3D 100
User connection=3D 20ish
All I/O's =3D less than 5
John
*********** 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
>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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart