Transcript Intro to the Class

Monitoring and Testing the
Network
Using Windows and Oracle Tools to
Determine Network Bandwidth and
Latency
Objectives



At the end of this module the student will
understand the following tasks and concepts.
How to monitor the network using Windows
Tools.
How to monitor the network using Oracle tools.
How to load test the network.
Network Monitoring





Perfmon
Task Manager
Oracle Wait Statistics
Pathping
Portquery
Perfmon

Objects





Network Interface
IPV4
IPV6
TCPV4
TCPV6
Task Manager

Provides some network information


Active interfaces
Percent utilization
Oracle Wait Stats

Use STATSPACK reports


Look for “SQL*Net message from client” wait events
Report lists:






Waits
Timeouts
Total Wait Time (s)
Avg Wait (ms)
Waits/txn
Look for relative ranking in wait events

A Top 5 or Top 10 ranking could indicate a problem
Pathping



The pathping utility is available with
Windows Server 2003
Used to display path and
performance of the path
Usage

pathping system
Portquery



The portquery tool is used to find the
ports and services open at an IP
address
Available from Microsoft
Command line or GUI tool
Network Load Testing

TTCP




Used for performance testing
Available on the Windows 2003 CD
Provides throughput information
Run on both transmitter or receiver
systems
Network Load Testing
TTCP

On receiving system


ttcp –r
On transmitting system

ttcp –t –n20480 192.168.50.101
Review




What are some of the network objects that can
be monitored in Perfmon?
Which network statistics can be monitored with
Task Manager?
What is the name of the most common Oracle
Wait event involving the network?
Name two additional network monitoring tools
available with Windows Server 2003.
Summary






Perfmon can be used for monitoring.
STATSPACK reports can give network
related Oracle Wait statistics
Pathping can be helpful for finding the
number of hops.
Task manager can provide some
information.
Portquery can help with security issues.
Use TTCP for load testing the network.