Live Performance Tracking

A few of the EQuIS Live agents allow their performance to be tracked, including:

•Data Inserts: The number of DT_LOGGER_DATUM rows that they insert.

•Errors: The number of errors that they encounter.

•Duration: The number of milliseconds that they take to process.

For each LoggerNet file or folder change, or report run, and for each DT_LOGGER row that it processes, the agent will add DT_LOGGER_SERIES and DT_LOGGER_DATUM rows for data inserts, errors, and/or duration.

Enabling

The performance tracking functionality is disabled by default. To enable it, add one or more rows to the ST_CONFIG table, with:

•CONFIG_SECTION = A namespace and class name from the table below
(e.g., EarthSoft.Live.Agents.LoggerNet.TOA5FileWatcher).

•CONFIG_KEY = performanceTracking

•OBJECT_VALUE = trackDataInserts, trackErrors, or trackDuration

•STRING_VALUE = true

Agent	Report Name	Namespace and Class Name
LoggerNet		EarthSoft.Live.Agents.LoggerNet.TOA5FileWatcher EarthSoft.Live.Agents.LoggerNet.TOA5FolderWatcher
Adcon	EQuIS Live: Adcon Data Collection Agent EQuIS Live: Adcon Historical Data Loader	EarthSoft.Live.Reports.AdconAgent EarthSoft.Live.Reports.AdconHistoricalDataLoader
In-Situ	EQuIS Live: InSitu Data Collection Agent	EarthSoft.Live.Reports.InSituAgent
NOAA NCDC	EQuIS Live: NOAA NCDC Agent EQuIS Live: NOAA NCDC Historical Data Loader	EarthSoft.Live.Reports.NoaaNcdcAgent EarthSoft.Live.Reports.NoaaNcdcHistoricalDataLoader
Outpost Central	EQuIS Live: Outpost Central Agent EQuIS Live: Outpost Central Historical Data Loader	EarthSoft.Live.Reports.OutpostCentralAgent EarthSoft.Live.Reports.OutpostCentralHistoricalDataLoader
USGS Water Services	EQuIS Live: USGS Water Services Instantaneous Values Agent EQuIS Live: USGS Water Services Daily Values Agent EQuIS Live: USGS Water Services Groundwater Levels Agent EQuIS Live: USGS Water Services Historical Data Loader	EarthSoft.Live.Reports.UsgsWaterServicesInstantaneousValuesAgent EarthSoft.Live.Reports.UsgsWaterServicesDailyValuesAgent EarthSoft.Live.Reports.UsgsWaterServicesGroundwaterLevelsAgent EarthSoft.Live.Reports.UsgsWaterServicesHistoricalDataLoader
Other?		If there's another EQuIS Live agent for which you want performance tracking, please contact EarthSoft.

Example: The following SQL enables performance tracking for the LoggerNet Agent.

IF OBJECT_ID('tempdb..#add_performance_tracking') IS NOT NULL DROP PROCEDURE #add_performance_tracking

CREATE PROCEDURE #add_performance_tracking(@config_section VARCHAR(128), @object_value VARCHAR(128), @string_value VARCHAR(2048)) AS

BEGIN

DECLARE @config_key VARCHAR(128)

SET @config_key = 'performanceTracking';

IF NOT EXISTS(SELECT * FROM st_config WHERE config_section = @config_section AND config_key = @config_key AND object_value = @object_value)

BEGIN

INSERT INTO st_config

(config_section, config_key, object_value, string_value)

VALUES

(@config_section, @config_key, @object_value, @string_value)

END

RETURN

END

EXEC #add_performance_tracking 'EarthSoft.Live.Agents.LoggerNet.TOA5FileWatcher', 'trackDataInserts', 'true'

EXEC #add_performance_tracking 'EarthSoft.Live.Agents.LoggerNet.TOA5FileWatcher', 'trackErrors', 'true'

EXEC #add_performance_tracking 'EarthSoft.Live.Agents.LoggerNet.TOA5FileWatcher', 'trackDuration', 'true'

EXEC #add_performance_tracking 'EarthSoft.Live.Agents.LoggerNet.TOA5FolderWatcher', 'trackDataInserts', 'true'

EXEC #add_performance_tracking 'EarthSoft.Live.Agents.LoggerNet.TOA5FolderWatcher', 'trackErrors', 'true'

EXEC #add_performance_tracking 'EarthSoft.Live.Agents.LoggerNet.TOA5FolderWatcher', 'trackDuration', 'true'

Live Performance Tracking Agent

Live Performance Tracking Agent

Enabling