What to monitor during stress test
We want to monitor our Oracle server during a test where we submit an unusually high amount of data to the server. On a server side, what are some of the key resources that we should monitor? On the application side, the same. Are there any tools out there that can be used to collect key data from Oracle? We are using Red Hat Enterprise 5 as our OS.
Apart from the above, If you want to monitor an oracle database or unix or linix box, there are plenty of tools/utilities/resources available which you can get by search from google or any search engine.
For example, if you specific about the application monitoring - then monitoring the weblogic/app server connections, database connections to see whether they are hitting the max number of allowed connections etc can be done to avoid app not crashing/becoming unresponsive/throwing errors etc.
What kind of app is yours and what is that used for ? If we have some more information, then we can give more responses/feedback related to that one and also we can try to keep that precise with respect to the context of your question.
Thanks,
For example, if you specific about the application monitoring - then monitoring the weblogic/app server connections, database connections to see whether they are hitting the max number of allowed connections etc can be done to avoid app not crashing/becoming unresponsive/throwing errors etc.
What kind of app is yours and what is that used for ? If we have some more information, then we can give more responses/feedback related to that one and also we can try to keep that precise with respect to the context of your question.
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to go the 'free' way, I suggest Statspack. It will do most of what is posted above and a lot more.
Oracle is trying to get away from this but it is still around.
This is a 9i doc but it should still apply up through 11gR2 (Haven't checked 12c).
http://docs.oracle.com/cd/E13160_01/wli/docs10gr3/dbtuning/statsApdx.html
Oracle is trying to get away from this but it is still around.
This is a 9i doc but it should still apply up through 11gR2 (Haven't checked 12c).
http://docs.oracle.com/cd/E13160_01/wli/docs10gr3/dbtuning/statsApdx.html
And what are you trying to learn or demonstrate with this test? Are you trying to be prepared for an increase in data or transaction volume that you know (or hope) may happen someday soon? Are you trying to demonstrate that your current server and storage hardware is adequate or inadequate? What kind of application is this: transaction processing, data warehouse, a mix, etc.? Is this a purchased application (if so, which one) or is this a custom application? Who set up the permformance-related parameters in your Oracle parameter file? Was that someone with a lot of experience managing Oracle on Linux for this kind of application? What kind of storage system do you have: NAS, SAN, etc.? Does it include some SDDs? Does your database use Oracle's ASM feature?
Unless you can help us understand what some of the business problems are that you are trying to solve, it is very difficult for us to give you specific help.
Unless you can help us understand what some of the business problems are that you are trying to solve, it is very difficult for us to give you specific help.
ASKER
Is there a place on this site to find a consultant for projects?
>>Is there a place on this site to find a consultant for projects?
Some Experts post that they are available for contract jobs in their profiles.
There is also a jobs board on the site:
http://careers.experts-exchange.com/
Some Experts post that they are available for contract jobs in their profiles.
There is also a jobs board on the site:
http://careers.experts-exchange.com/
I suppose monitoring the application depends on things like: What is it written in?