Imperva Cyber Community

Gateway Throughput Tracker Script 

03-02-2021 10:05

When this bash script runs each time, it checks and (if it is not present) creates "/var/tmp/scripts/hades_outputs" folder on GW. Then it creates statistics files (as CSV format) for each Server Group under this folder and fills them with throughput values (application throughput, HTTP hits/sec, SQL hits/sec) of related Server Groups. In addition to Server Group statistics files, it also creates Total Throughput statistics CSV file and fills it with GW's total and application throughput values.

You can schedule it as cronjob to track Gateway Total throughput statistics and each Server Groups' specific throughput values for specific time interval.

Sample SS is below:


For more information about hades statistics:
https://docs.imperva.com/howto/0c0def26 - Performance--How to determine throughput and number of connections per second for a specific server group?
https://docs.imperva.com/howto/e8c6d396 - Behaviour of Gateway CPU when handling traffic
https://docs.imperva.com/howto/6a748561 - SQL--SQL Hits vs Query Hits

Edit: I have updated the script (named as hades_stats_v2.zip) with new regex used for Server Group name parsing. Previously, If server group name contains digit, regex does not work correctly.

#DatabaseActivityMonitoring
#On-PremisesWAF(formerlySecuresphere)
#AllImperva

Statistics
0 Favorited
30 Views
1 Files
0 Shares
5 Downloads
Attachment(s)
zip file
hades_stats_v2.zip   559 B   1 version
Uploaded - 03-04-2021
compressed version of bash script

Tags and Keywords

Related Entries and Links

No Related Resource entered.