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 on the Toolbar.
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.
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.
The following options are available in the Conflict Viewer:
|Show Schedule Conflicts Over||Use 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 Time||Use this setting to eliminate noise caused by short-running events.|
|Close||Closes the Conflict Viewer window.|
|Apply||Apply any selected Show Schedule Conflicts Over and Minimum Conflict Time filter changes.|