RE: Interactive activity approaching capacity of installed featur e

Sorry brain fart.  I looked at the wrong column.  you are right 120 cpw
for interactive.


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






"Burns, Bryan" <burnsbm@Echoincorporated.com>
Sent by: midrange-l-admin@midrange.com
04/02/2002 04:57 PM
Please respond to midrange-l


        To:     midrange-l@midrange.com
        cc:
        Subject:        RE: Interactive activity approaching capacity of 
installed featur       e


It is my understanding that the upgrade took us from 85.6  to 120 CPW
interactively, but 370 for batch.


-----Original Message-----
From:            bdietz@3x.com [SMTP:bdietz@3x.com]
Sent:            Tuesday, April 02, 2002 3:58 PM
To:              midrange-l@midrange.com
Subject:                 Re: Interactive activity approaching capacity of
installed
feature

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.

_______________________________________________

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.