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...
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'
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)
Restart the new three Databases using a Command Prompt at the Server\Configuration folder.