Using current and historical data, SQL Diagnostic Manager uses statistical analysis to estimate the likelihood that an event generates a particular alert. This forecasting lets you proactively focus on certain areas in your SQL Server environment and prevent problems from occurring.
SQL Diagnostic Manager begins building forecasting models once you receive three critical or warning alerts for a given metric.
The 12-hour Forecast is separated into two-hour segments. Each two-hour segment displays the chance of an alert occurrence. Click the associated percentage chance to see the alert forecast details. This window displays the alerts that may occur over the two-hour time segment.
12 Hour Forecast icons
Icon | Description |
|---|---|
| OK - There is a low chance (less than 20%) that a warning or critical alert occurs in the two-hour time segment leading to the forecast time. |
| Warning - There is a moderate likelihood (less than 50%) that a critical alert occurs, or a high likelihood (50% or higher) that a warning alert occurs, in the two-hour time segment leading to the forecast time. |
| Critical - There is a very high likelihood (50% or higher) that a critical alert occurs in the two-hour time segment leading to the forecast time. |
