Monitoring Network Performance - Query Needed

UJJWAL_RANA

Hi,

I wonder if there if it is possible to monitor the network performance from vertica database ? I am looking for the  query statement inorder to monitor the network performance.

 

Please suggest.

 

Thank You

 

Ujjwal Rana

 

 

Adrian_Oprea_1

 

• 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'

 

SruthiA

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

[Deleted User]

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.