There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
most recent failed execution failed
I built 8 ssis reporting pack connected on different 8 servers.
On 2 servers, the report "most recent failed execution" never end.
I applied the corrections of indexing [internal].[event_message_context], [internal].[executable_statistics], [internal].[operation_messages], [internal].[event_messages], [internal].[execution_component_phases] and modified the procedure [internal].[append_execution_component_phases]
with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE.
I have about 2 M rows in event_messages, operation_messages and event_message_context