API Definition
REPLACE PROCEDURE TDStats.DailyTuningOverhead (
IN jIn JSON(2000) CHARACTER SET UNICODE)
DYNAMIC RESULT SETS 1 ;
JSON Input Keys
| JSON Key | Data Type | Description |
|---|---|---|
| BeginDate | DATE | Starting date for resource usage. |
| EndDate | DATE | Ending date for resource usage. |
| LogDatabaseName | VARCHAR(128) | Source of DBQL telemetry that reports resource usage. Valid values are:
Default is 'TD_METRIC_SVC'. |
| ByJob | BOOLEAN | Break down results by AutoDba Tuning Job. Default is false. |
| ReturnTable | BOOLEAN | When true, results will be stored in a session level temporary table named AutoDBA_DailyTuningOverhead rather than being returned as a dynamic result. Default is false. |
Dynamic SQL Result Columns
| Column Name | Data Type | Description |
|---|---|---|
| ReportDate | DATE | Date of reported usage. |
| AutoDbJobName | VARCHAR(25) | Name of AutoDb service job. Returned only when input parameter ByJob is true. |
| StatsAnalysisAmpCPUTime | FLOAT | Amp CPU usage from statistics tuning analysis operations. |
| StatsAnalysisParserCPUTime | FLOAT | Parser CPU usage from statistics tuning analysis operations. |
| StatsAnalysisTotalIOCount | FLOAT | IO usage from tuning statistics analysis operations. |
| StatsCollectAmpCPUTime | FLOAT | Amp CPU usage from statistics collections. |
| StatsCollectParserCPUTime | FLOAT | Parser CPU usage from statistics collections. |
| StatsCollectTotalIOCount | FLOAT | IO usage from statistics collections. |