• First, when a cluster instance is started, you can check if the active node has changed. The active node name is captured in the [SQL_Overview].[dbo].[SQL_Servers] table. You can add a column to the SSIS_ServerList to track the active node and create a special report when it changes.

    If the instance is restarted multiple times in the day, the SQL Overview error log report could be updated to include records of it happening. It might already.

    I personally watch for unexpected instance restarts and if it is a cluster, I check the windows event log to find the cause of the failover. Most of our cluster failovers are caused by window security patching.

    David Bird