To all DBAS: guidance reg monitor network traffic

[jlakhani]

Hi
the problem I know I have is users complaining of how slow the network is and I need a way to trace number of hops a packet has to make to reach it's destination or a way to monitor specific network traffic. For all you expert DBAs who have faced a similar situation where your database is optimally tuned but network plays a big part in response how do we monitor the network so that we can leverage that our database isnt the source of problems????
If somebody has a script which does traceroute or something i would like to know about it.

thanks
jigar

[tamilselvan]

In Unix, you can use netstat -i 5 5 command.

But, you need to run this command very often to figure out whether the network has collision problems. If the value under collision is very large, then your network's bandwidth is small.