Monitoring and Testing the Network

1
Monitoring and Testing the Network

• Using Windows and Oracle Tools to Determine
  Network Bandwidth and Latency

2
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.

3
Network Monitoring

• Perfmon
• Task Manager
• Oracle Wait Statistics
• Pathping
• Portquery

4
Perfmon

• Objects
• Network Interface
• IPV4
• IPV6
• TCPV4
• TCPV6

5
Task Manager

• Provides some network information
• Active interfaces
• Percent utilization

6
Oracle Wait Stats

• Use STATSPACK reports
• Look for SQLNet 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

7
Pathping

• The pathping utility is available with Windows
  Server 2003
• Used to display path and performance of the path
• Usage
• pathping system

8
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

9
Network Load Testing

• TTCP
• Used for performance testing
• Available on the Windows 2003 CD
• Provides throughput information
• Run on both transmitter or receiver systems

10
Network Load TestingTTCP

• On receiving system
• ttcp r
• On transmitting system
• ttcp t n20480 192.168.50.101

11
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.

12
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.