RE: N/w Bottleneck Check using tnsping under Tran. Load ... Basic Qs
Date: Sat, 31 May 2008 01:22:28 +0530
Message-ID: <69E1360E54B50C4A828A136C158E474203AAAF9662@BLRKECMBX02.ad.infosys.com>
Thanks V much Tanel for responding, as always.
CPU Usage of BOTH DB & APP Servers is about 30 % only at Peak Load when tnsping is giving a Timing of 118 ms. Hence do Not expect any CPU runqueue.
From: Tanel Poder [mailto:tanel.poder.003_at_mail.ee] Sent: Friday, May 30, 2008 8:27 PM
Hi,
The listener process needs to get onto CPU in order to answer to your tnsping request, so if your CPU runqueues are long during peak load test, it will take a while before listener can reply to your request.
For testing purposes you could set the listener onto real time priority class and see if the results change.
But your network guys should be able to say whether your network is saturated, as they have access to various link level stats etc.
Regards,
Tanel Poder
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Friday, May 30, 2008 19:15
Folks
. . .
Is following an appropriate pointer to check for Network Choking under (Benchmark) Transaction Load?
Running of tnsping periodically during Peak Benchmark Transaction Load hitting the SAME IP Address / Port Num as the Application. tnsping under concurrent Benchmark Tran load is giving a Timing of 118 milli seconds. This seems to indicate a Network choke. (Under NO Load tnsping returns a Timing of 0 milli seconds.)
Any Other HP-UX Command(s) that give % of Network Usage (of 100 MBPS LAN) between APP & DB Server?
NOTE - Dedicated Server process connections to Database.
CONFIG:-
HP-UX
Oracle 10.2
- CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 30 2008 - 14:52:28 CDT