Use the Degrading SQL Configuration options to:
To set the Degrading SQL Configuration options
Configure the following options:
|Degrading SQL Cost Metric||
Select the SQL Cost Metric you want to use when making your prediction.
Specify how far you want to look into the future.
Note: Because each prediction is based only on the existing raw data, the forecast becomes less accurate the further you look into the future.
When the Cost Metric increases at an increasing rate (follows an exponential trend), the cost may ultimately grow so large that it over-emphasizes the importance of the analyzed metric relative to others.
Use the Prediction Limit Multiplier option to define a realistic upper limit on the cost of the SQL statement. Beyond this point, the predicted growth will be ignored. By default, the upper limit is set at 100 times the largest cost value observed so far.
You can set Spotlight to automatically suggest any Trend Changes in the data it collects. Use the available options to control which changes are suggested.