Tuning IRDBASE when Prognosis is Overloaded

In large instances of Advanced Reporting solutions with high data throughput, the IRDBASE processes collecting the 'BigDataInsight_xxxx' databases, particularly 'BigDataInsight_1Minb' may become overloaded and unresponsive.

Use the following procedure to fine tune the SQL Reporting solution when the IRDBASE for 'BigDataInsight_1Minb' becomes overloaded and unresponsive.

Locate the folder containing the BigDataInsight deployment Database template files, <Prognosis_Home>\Server\Configuration\BigDataInsight\<deployment>\PrognosisScripts\deployed

Make 2 copies of the StartBigDataInsightUC_1Minb.dbc, 1Minc and 1Mind...

copy StartBigDataInsightUC_1Minb.dbc StartBigDataInsightUC_1Minc.dbc
copy StartBigDataInsightUC_1Minb.dbc StartBigDataInsightUC_1Mind.dbc

Edit each of the three template files such that there is approximately 1 third of the VIEW blocks in each file.

There are approx 85 VIEWS defined, so this would leave approx 28 VIEWS defined in each of the files.

Rename the DB Name and LOCATION at the top of each file to match the filename, i.e. '_1Minc' and '_1Mind'

For Example:

START DBCOLLECT
   DB "{{DBC_NAME}}_1Minc"
   LOCATION "{{DBC_NAME}}_1Minc"

Manually stop the IRDBASE.EXE process responsible for 'BigDataInsightUC_1Minb', to locate this in Task Manager (or similar), view the 'Command Line' to show the Database collection name.

Delete the Database folder <Prognosis_Home>\Server\Configuration\BigDataInsightUC_1Minb

Update the IRDBASE.INI file to setup the new Database Collections as Null Enabled (MS SQL Server)

[NULLENABLED]
EnableAll=N
Enabled=BigDataInsightUC_10Sec
Enabled=BigDataInsightUC_12HR
Enabled=BigDataInsightUC_1HR
Enabled=BigDataInsightUC_1Mina
Enabled=BigDataInsightUC_1Minb
Enabled=BigDataInsightUC_1Minc
Enabled=BigDataInsightUC_1Mind
Enabled=BigDataInsightUC_30SEC
Enabled=BigDataInsightUC_5Min
Enabled=BigDataInsightUC_6HR

Restart the new three Databases using a Command Prompt at the Server\Configuration folder.

C:\Prognosis\Server\Configuration> ..\ircmd.exe BigDataInsight\<deployment>\PrognosisScripts\deployed\StartBigDataInsightUC_1Minb.dbc
C:\Prognosis\Server\Configuration> ..\ircmd.exe BigDataInsight\<deployment>\PrognosisScripts\deployed\StartBigDataInsightUC_1Minc.dbc
C:\Prognosis\Server\Configuration> ..\ircmd.exe BigDataInsight\<deployment>\PrognosisScripts\deployed\StartBigDataInsightUC_1Mind.dbc



Provide feedback on this article