KBI 311128 New Feature: Single Argent AT Global System Registry Defaults TCP And SQL Server
Version
Argent Advanced Technology 3.1A-1501-A and later
Date
Tuesday, 16 Dec 2014
Thursday, 22 Feb 2018: updated with default values in 1710-A
Friday, 6 Apr 2018: updated with new default values for 1804-A
Summary
Argent AT products have some SQL and TCP related registries
In versions earlier than 3.1A-1501-A, the registries reside in product-specific registry hive
As a result, it is possible that one product has values needlessly different from another
Recently the common issue occurred when the Argent SQL Server database backend was offline for 5 minutes
The Argent Console Engine went into hard shutdown, as it was supposed to do, as its SQL Server timeout was set to 3 minutes
(A hard shutdown requires manual intervention to restart the service)
However, the Argent Guardian Ultra Engine’s SQL Server timeout was set to 60 minutes
As a consequence, the Argent Guardian Ultra Engine kept running for a week before the harried customer Admin noticed no Alerts were being fired by the Argent Console
When the aforementioned harried admin started the Argent Guardian Ultra GUI, everything appeared in order
This is clearly a design error in Argent AT and has been corrected
In version 3.1A-1501-A, these common keys are moved to HKLM\SOFTWARE\ARGENT\COMMON so that it is a single place to maintain these registries
The affected registries include:
| Registry Key | Default Value | SQL_QUERY_TIMEOUT | 0 | SQL_OUTAGE_ALLOWED_IN_MINUTE | 15 | SQL_OUTAGE_ALLOWED_IN_MINUTE (1804-A and later) | 60 | ODBC_TXTBUF_IN_KB | 32 | ODBC_INIT_ATTEMPT_TOTAL | 3 | ODBC_INIT_ATTEMPT_INTERVAL | 1 | ODBC_UPDATE_QUERY_ATTEMPT_TOTAL | 3 | ODBC_UPDATE_QUERY_ATTEMPT_INTERVAL | 1 | TCP_SEND_TIMEOUT | 30 | TCP_RECV_TIMEOUT | 30 | TCP_TRACERT_TIMEOUT | 3 | TCP_PING_TIMEOUT | 3 | TCP_PING_RETRY | 3 | TCP_ENCRYPT_LEVEL | 0 | TCP_MAX_ALLOWED_CONNECTION | 30 | TCP_MAX_ALLOWED_CONNECTION (1804-A and later) | 200 | TCP_CONNECT_WAIT | 3,000 | TCP_CONNECT_RETRY | 1 |
Added in 1804-A: AUTO_EXPORT_MOTHER_CONTROL_INFO
Moved from the individual product’s registry hive to HKLM\Software\Argent\COMMON so that the setting is shared by all products
| AUTO_EXPORT_MOTHER_CONTROL_INFO | 15 |
This means mother control information is automatically exported 15 minutes after the last change is made for all installed Argent products
Technical Background
The reasons for the above changes to existing defaults in 1804-A and later are as follows:
SQL_OUTAGE_ALLOWED_IN_MINUTE
Often times customer’s maintenance on SQL Server (especially on the weekends) take more than 15 minutes, thus the default has been changed to 60 minutes
The balance that needs to be struck is between hard shutdown to make SQL Server errors obvious versus wasting customer’s time
TCP_MAX_ALLOWED_CONNECTION
With the increasing use of Argent Daughter Engines, 30 TCP connections sometimes can cause needless aggravation for customers
Thus the default has been increased to 200
A Word On SQL Server Bulk Insert
SQL Server Bulk Insert should always be used
So why is it not turned on by default?
Because some work needs to be done by the SQL Server Administrator; for details see:
KBI 310359 Enabling SQL Bulk Insert In Argent Guardian Ultra And Argent For Compliance
The above values are the defaults – customers can judiciously change these to suit their own environments
Resolution
Upgrade to Argent Advanced Technology 3.1A-1804-A or later