Version

Argent Advanced Technology 5.1A-1807-A and below

Date

Tuesday, 4 September 2018

Summary

SQL Bulk Insert must be turned on to save large volume of Argent Predictor data

Argent Commander Dashboard can be configured to show the collected Argent Predictor data

However, user might find the data is always late for one or two hours, sometimes even longer than that

The data will eventually show up only a few hours later

As a result, the displayed data is not up-to-date, and recent data is consistently unavailable

The issue has been addressed in Argent Advanced Technology 5.1A-1810-A

Technical Background

When SQL Bulk Insert is turned on, Argent Advanced Technology Engine writes to-be-saved data in temporary DAT file in a share at SQL Server

Argent Advanced Technology Engine has a dedicated worker thread to run a SQL Bulk Insert query for each DAT file in the network share

When data volume is high and large amount of DAT files are generated all the time, the single worker thread running SQL Bulk Insert query SEQUENTIALLY might not be able to catch up

As a result, DAT files could be accumulating and performance data would be late to be saved into SQL database

Argent Advanced Technology 5.1A-1810-A addresses the issue by using a thread pool so that multiple SQL Bulk Insert queries can be executed concurrently

By adjusting the pool size, the performance data saving delay issue can be addressed properly

The thread pool size is controlled by DWORD value of registry HKLM\Software\Argent\{PRODUCT}\SQLBI_THREAD_COUNT

The valid value is 0 – 100

The default value is 0, which means no thread pool is used and compatible with the old sequential processing

Resolution

Upgrade to Argent Advanced Technology 5.1A-1810-A or above

Edit value of registry HKLM\Software\Argent\{PRODUCT}\SQLBI_THREAD_COUNT to 30