cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 13

What are the consequences of increasing the Baseline Data Collection Duration?

Jump to solution

What tables are used in storing this data. Is there a way to estimate the impact of increasing the 7 day Baseline Collection to 14 days? to 28 days?

0 Kudos
1 Solution
Level 12

Hello,

The baseline statistics are collected from APM_ComponentStatus_Detail, APM_PortEvidence_Detail, APM_ProcessEvidence_Detail and APM_DynamicEvidence_Detail tables. If you want to increase Baseline Collection setting then you have to also increase retention period for Detail tables in SAM. So then the amount of data and size of these tables will increase (based on number of days) and it could have impact for performance of the charts, historical reports, DB maintenance etc. The impact depends on number of components and performance of SQL server:

  • if you have less than 1000 components then you probably won't recognize any impact
  • if you have less than 10000 components then the loading of charts and reports can be little bit slower
  • if you have more than 10000 components then I recommend to do it only if you have strong SQL server

Lukas Belza (SolarWinds development)

View solution in original post

0 Kudos
3 Replies
Level 12

Hello,

The baseline statistics are collected from APM_ComponentStatus_Detail, APM_PortEvidence_Detail, APM_ProcessEvidence_Detail and APM_DynamicEvidence_Detail tables. If you want to increase Baseline Collection setting then you have to also increase retention period for Detail tables in SAM. So then the amount of data and size of these tables will increase (based on number of days) and it could have impact for performance of the charts, historical reports, DB maintenance etc. The impact depends on number of components and performance of SQL server:

  • if you have less than 1000 components then you probably won't recognize any impact
  • if you have less than 10000 components then the loading of charts and reports can be little bit slower
  • if you have more than 10000 components then I recommend to do it only if you have strong SQL server

Lukas Belza (SolarWinds development)

View solution in original post

0 Kudos


Thank you.

Is there any way to select only the components you are intrested in increasing?

For example: Server X and Y because they are financial in nature and we need a full period for accurate baseline measurement.

0 Kudos

Not at this time. The baseline statistic data retention period is a global setting that effects all components across all applications. The basis of a statistical baseline is that it's a quiet period of time when all statistical data collected is considered "normal" behavior for the environment  If it was extended beyond a reasonable time period, you would likely find greater occurrences of anomalous variation outside the "norm" that would be factored into the statistical baseline, thus defeating the purpose of a baseline. Consequently, this is also one of the reasons why moving baselines tend to be considered far less accurate, because they can often times hide legitimate problems in the environment as these anomalies are calculated into the baseline. As such, these anomalous values are considered "normal" resulting in no thresholds being crossed, and no alerts being raised, when illegitimate issues are occurring in the environment.