× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.