The Timeline view provides a chronological chart of events that affect your monitored SQL Server instance. The view details the point in time for this monitored SQL Server instance when an alert occurred, including custom counter alerts.
SQL Diagnostic Manager displays as many alerts as can fit in the window and uses color codes based on the alert type as shown in the key below the menu. While a single Timeline point can represent more than one alert, the point itself appears in the color of the most critical alert for that time.
Use the filters to pinpoint the information you want to view. If the displayed timeframe is not exactly what you want to view, select another period from the Filter drop-down list. Notice that the measurement at the bottom of the window changes from hours to days if you switch from a daily option to one over a period of days. Select Pick a Day to select a specific day using the calendar.
You can also use the time frame slider at the bottom of the view to zoom in or out by dragging the start and end bars to the desired position. Click the left or right arrows to move your set range to another period in the timeline. SQL Diagnostic Manager retains the range size, but changes the results based on the dates within the range.
SQL Diagnostic Manager displays alerts on the Timeline in your local time even if the monitored SQL Server instance where the event occurred is located in a different time zone.
Access the Timeline view
You can open the Timeline view of the SQL Diagnostic Manager Overview tab by selecting the appropriate SQL Server instance, and then clicking Overview > Timeline.
Access more alert detail from the Timeline
View the total number of alerts at a specific time
When you hover your cursor over a point in the timeline, SQL Diagnostic Manager displays the number of alerts for the time displayed in the timestamp.
Zoom in for more detail
Your alert configuration may cause the Timeline view to appear cluttered in the default settings. Occasionally, a timeline point appears without an attached alert flag to let you know about the associated alert. If you experience these issues, use the time frame slider at the bottom of the view to zoom in for a clearer picture of a set of alerts.
View alerts
While the Timeline provides your alerts in chronological format, you may want to view more detail about a single alert while using this view. To access the Alerts view from the Timeline, simply right-click the alert and select View Alerts. SQL Diagnostic Manager displays the view you receive when you click the Alerts pane for a monitored SQL Server instance.