Re: Interactive activity approaching capacity of installed feature

[bdietz@xxxxxx]

Your "old" 620-2179 had a CPW of 85.6 of which all could be interactive
your 820/2395-1523 only allows for 35 CPW of 370 total for interactive.

One question is how much of your 620 was interactive workload?  that might
be hard to determine.

Yes it could be cause by users running queries interactively, maybe they
can be submitted to batch.  You have 335 CPW dedicated to batch on the
820.

I do not think the ODBC jobs will hurt the system as they are batch jobs
and do not count against your interactive limit.


-------------------------
 Bryan Dietz
3X Corporation

=============================

Should I spend the time to pursue the root cause of this?  We have
had no performance issues since we upgraded from a 620-2179 to an
820-2395-1523 last fall.

Could this be caused by queries?  We have over 6,000 queries and 275
users on our box and most users run their queries interactively.

Could this be caused by SQL?  We recently started some applications
that use SQL through ODBC.  I turned the SQL monitor in OPS NAVIGATOR on
for
a few hours one day and did an analysis but did not find anything
significant.