Tuning Steps for High Performance Reporting Engine

Tuning Steps for High Performance Reporting Engine

Follow All the Steps as mentioned below:

1. Login to the High Performance Reporting Engine server (if installed in a remote server)with the Administrator login that used during the time of the High Perf installation.
2. You should have at-least 8 GB RAM on the server for the better performance.
3. Open command prompt as Administrator
4. Execute ingstop -service 3 times
5. Make sure there is no Actian or vectorwise service running in the task manager.


Follow the below step to Tune High Performance Reporting Engine :

1. Open the file named vectorwise.conf from under Actian\VectorwiseVW\ingres\data\vectorwise\ and search the below parameters and edit the changes as given below:

max_overalloc=0
max_memory_size=10G  // 8G for 16 GB RAM ; 4G for 8 GB RAM
num_cores=8              // 8 if the CPU is Dual Core with HT ; 4 if the CPU is 1 core with HT
max_transactions=110
io_prefetch_blocks=24
queue_depth=48
bufferpool_size=6G  // 4G for  16 GB RAM ; 2G for 8 GB RAM
block_size=2M
group_size=8
max_parallelism_level=2

Add the below 2 entries at the end of the vectorwise.conf:

enable_aggregation_disk_spilling=true 
enable_hashjoin_disk_spilling=true



2. Open the file named config.dat from Actian\VectorwiseVW\ingres\files, search and edit the properties and mentioned below:

ii.nfaxen-cent1.dbms.*.connect_limit:   100
ii.nfaxen-cent1.gcn.session_limit:      100

//Where nfaxen-cent1 is the machine name in it. Please Edit it, don't replace.


3. Once done, restart the High Performance reporting Engine server and check on the issue.
          • Related Articles

          • Issue with HighPerformance Reporting engine v3.5.1 during the initial startup

            Please download and extract the patch from the below link: https://uploads.zohocorp.com/Internal_Useruploads/dnd/NetFlow_Analyzer/o_1a4te9phs1ld1puf1b931mat1pl61/20150611175728-actian-vector-3.5.1-448-win-x86_64-p44838.zip Steps: 1. Stop the NetFlow ...
          • Steps to Reduce the DISC SPACE for NetFlow Analyzer ( rawCleanup )

            Please follow the below steps to reduce the Disc space storage in NetFlow Analyzer: 1. Stop NetFlow Analyzer service. 2. Open command prompt as administrator and navigate to NetFlow_Home/troubleshooting 3. Execute rawCleanup.bat and wait until the ...
          • Steps to create a new user in VectorWise database for Windows till 12.4

            Steps to Create a new user in VerctorWise database build 3.5.1 Steps if the HighPerf Reprting Engine is installed in the same server where the NetFlow Analyzer is installed: 1. Stop the NetFlow Analyzer service. 2. Download and extract the file named ...
          • Firewall Analyzer Mysql to Pgsql migration steps.

            Stop the Firewall Analyzer Service. Take the backup or a VM snapshot of ManageEngine\Firewall folder. Download the correct zip files based on your OS(32/64bit) from the below link and extract it under <Firewall Analyzer Home>. ...
          • Steps to resolve to "Too many open files" in Linux

            Please follow the below steps to resolve the issue with  "Too many open files" issue in Linux. Follow below given steps: 1. Stop the NetFlow Analyzer service. 2. Please visit the link given below for the steps to increase the open files in the Linux ...