Buck, I agree with you, but this is a pretty straightforward question. It has, of course, been covered over and over in these archives.
CPU constantly at 100% is a very strong indication your system is in "thrash" mode. That's where so many jobs using so much memory are running at one time, the system is spending all its resources swapping memory pages from physical memory to virtual memory. So much so that it can't get any of the actual work done that it is needing the pages to do.
Now as to solving thrash, I refer you to the archives. Google something like "thrash site:midrange-l.com". There's lots of things that may be done depending on your workload, your software, your hardware, and the configuration of all those things. One I'll mention is one others have mentioned before, queries running to satisfy reports can be huge memory hogs if poorly structured. Actually they can be huge memory hogs even if properly structured, but we've learned how to cope with that: see the archives.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck Calabro
Sent: Tuesday, June 04, 2013 10:46 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: MIDRANGE-L Digest, Vol 12, Issue 1207
On 6/4/2013 9:57 AM, Crystal Reports wrote:
I honestly don't understand what is wrong with having a general discussion about system performance.
General discussions are not easy via an email mailing list. Stack Overflow does not even *allow them*:
'You should only ask practical, answerable questions based on actual problems that you face. Chatty, open-ended questions diminish the usefulness of our site and push other questions off the front page.
'Your questions should be reasonably scoped. If you can imagine an entire book that answers your question, you're asking too much.
'If your motivation for asking the question is "I would like to participate in a discussion about ______", then you should not be asking here. However, if your motivation is "I would like others to explain ______ to me", then you are probably OK. (Discussions are of course welcome in our real time web chat.)'
http://stackoverflow.com/faq#dontask
WHy should I not want to see if I can help the system?
You should want to be useful.
It is my opinion that this is the stage of your education where you MUST start with the reference material. You have had enough exposure to the vocabulary to get you going. Search the archives of this list and see what other people have asked and how answers have come in. Go to the Infocenter. Use the vocabulary you have acquired and search the relevant portions so you can see /how/ to gather data in order to begin to make decisions on performance.
For the archives, performance tuning is HARD. Every machine is different because of the individual workload it has to carry, because of the individual database and the individual data set within that database. If you want to have a discussion on performance, you'll need to post specifics about the machine: model, memory pools, activity levels, disk arms and utilisation for starters.
A general performance discussion goes like this:
Q: My machine's performance is not good.
A: Buy a bigger machine.
Q: I can't afford a bigger machine!
A: Reduce the workload.
Q: I can't reduce the workload!
A: Then performance is acceptable to the business, by definition.
--buck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
