SQL Sentry Conflict Viewer

Event conflicts are often one of the greatest contributors to performance problems on a SQL Server. The Conflict Viewer provides valuable insight into how event schedules are contending with each other. It enables quick and easy cleanup of conflict conditions, ensuring your event schedules are leveled. To open the Conflict Viewer, select the View Schedule Conflicts icon SQL Sentry Conflict Viewer toolbar button resembling a yellow sign with two red arrows pointing at each other. on the Toolbar.

Event Calendar in the Calendar view with the Conflict Viewer button selected and highlighted.

The Conflict Viewer is initially sorted in descending order by Total Conflict Time, which is the total time an event conflicts with other events. This measure is extremely valuable in determining which event objects may be causing the most resource contention. The primary event object is listed with its detail information, including Name, Start Time, End Time, and Duration. The event objects that are conflicting with it are listed beneath it along with their detail information, as well as the actual time in conflict.

SQL Sentry Schedule Conflicts between window for the Londonsql01.se.local instance.

Double-click any conflict record to jump directly to the corresponding job instance on the calendar. From there, you can use drag-and-drop to reschedule the associated events and clean up the conflict condition. This is the quickest and most effective way to level an event schedule.

Note:  The Drag-and-Drop feature is disabled in the evaluation copy of SQL Sentry.

Viewer Settings

Schedule Conflicts between window toolbar displaying the conflict filter options.The following options are available in the Conflict Viewer:

OptionDescription
Show Schedule Conflicts OverUse this setting to set the time range over which you want to view conflicts. The Conflict Viewer starts at the current time and projects out into the future by the specified amount.
Minimum Conflict TimeUse this setting to eliminate noise caused by short-running events.
CloseCloses the Conflict Viewer window.
ApplyApply any selected Show Schedule Conflicts Over and Minimum Conflict Time filter changes.