Monitoring Network Performance - Query Needed

• Use Vertica provides Vnetperf utility.

Example :

 /opt/vertica/bin/vnetperf --condense --hosts 10.20.100.66,10.20.100.67 --identity-file '/root/.ssh/vid_rsa'

Hi,

  Adding to what Adiran has mentioned, There is a system table called network_usage which contains history of network bandwidth usage.

select * from network_usage;

 For more information, Please refer to http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/NETWORK_USAGE.htm?Highlight=network_usage

-Regards,

 Sruthi

Be careful with what Adrian suggested. That simulates Vertica network activity, it is to see the network throughput not to monitor the network activity. Actually it will add A LOT of network traffic while you run it. So it is to measure performance not to monitor network performance during your cluster activity. Actually is recommended to measure that performance when the db is down.