We can currently NOT access any accounts on the Accounts page due to a timeout error
Exception occured while executing a reader for
SELECT * FROM dbo.[DeploymentProcess] WHERE ([JSON] LIKE @accid) ORDER BY [Id] SQL Error -2 - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The wait operation timed out
In digging in we found that it takes 30 to 40 seconds for the query to respond back and brings back around 540mb of data. It looks like the timeout is 1min and I guess processing the data is also takeing 30+ seconds. The table currently is at 3479 rows. We are looking at our retention and where we can tighten up but as we add more projects to octopus (currently 232) I feel we are going to run in to this again. Maybe searching through the json isn’t scalable?