mildmanneredjon

Results 3 comments of mildmanneredjon

SQL timeouts when searching events, publishing or loading a runbook snapshot - Execution Timeout Expired

We are experiencing the same timeouts when loading a runbook snapshot (running Octopus version 2023.2 (Build 12998). I don't think this is an index issue. This is due to the...

SQL timeouts when searching events, publishing or loading a runbook snapshot - Execution Timeout Expired

Further analysis and testing has provided another solution and that is to eliminate the key lookups caused by the index not having all columns in the INCLUDE. They way to...

SQL timeouts when searching events, publishing or loading a runbook snapshot - Execution Timeout Expired

@LukeButters it was only occurring when a bad plan was chosen