Display Event Markers to see when DBO events occurred
Event Markers show users when certain DBO events occurred, such as configuration changes, agent starts or stops, and schema changes. By comparing performance data before and after the change, you can correlate database performance changes with specific events that occurred during the same time window.
This feature requires the updated layout to be enabled.
See the following sections:
Display Event Markers on a Profiler tab
To display Event Markers on a Profiler tab, the updated layout must be enabled.
-
Specify the monitored instance or instances whose Event Markers you want to view:
-
To view Event Markers for a single database instance:
-
Click Databases.
-
In the list of database instances, click the instance name. The instance details view opens.
-
Click the Profiler tab, and then click the Profiler Chart arrow to display the chart.
By default, the chart displays the Top 10 Queries by Total time for the last hour.
-
To view different queries, change the selected time range or apply different filters.
-
-
To view Event Markers for multiple database instances:
-
Click Databases.
-
Click the Profiler tab, and then click the Profiler Chart arrow to display the chart.
By default, the chart displays the Top 10 Queries by Total time for the last hour.
-
To view different queries, change the selected time range or apply different filters.
-
-
-
Click the
button in the upper-right corner. The Event Markers drop-down menu displays the event types that occurred for the queries shown on the Profiler Chart during the selected time period. If no events occurred during that time period, it displays the message
No Events Types. -
Click the Show Event Markers toggle to enable it.
-
Select the check box next to each type of event marker you want to display. You can select up to five types.
-
Click the
button again to close the drop-down menu. Event Markers are shown as color-coded circles at the bottom of the Profiler chart. Hold the mouse pointer over an Event Marker to display information about the event.
A maximum of 500 Event Markers can be displayed per query.
Display Event Markers on an Inspector view
-
Click Databases.
-
Click Inspector.
-
On the Inspector tab, create a new inspector view, or click the name of an existing view to open it.
-
Click the
button in the upper-right corner. The Event Markers drop-down menu displays the event types that occurred for the queries shown on the Profiler Chart during the selected time period. If no events occurred during that time period, it displays the message
No Events Types. -
Click the Show Event Markers toggle to enable it.
-
Select the check box next to each type of event marker you want to display. You can select up to five types.
-
Click the
button again to close the drop-down menu. Event Markers are shown as color-coded circles at the bottom of the Profiler chart. Hold the mouse pointer over an Event Marker to display information about the event.
A maximum of 500 Event Markers can be displayed per query.