We’ve been using our Octopus Deploy server for over 2 years now and are currently at version 3.13.8. In the last couple weeks we’ve noticed extremely slow response times via the web ui with lots of query timeout error messages. During our last 2 server reboots Octopus server has taken 30 - 40 minutes to come up and start accepting requests (via web ui). Nothing seems out of the ordinary and our projects have remained fairly static over the last 3 months or so (just minor process tweaks here and there). The culprit query timeout occurs when trying to view the overview tab of just about any project:
SELECT * FROM dbo.[MultiTenancyDashboard] WHERE ([ProjectId] = @projectId) ORDER BY [Id]
What’s interesting is we only have one project that uses the multi-tenant feature but every project overview fails with the above query timeout.
- Server startup time ~30-40 minutes
- CPU is almost always pegged 100% with Octopus Server by far the heaviest usage even though 0 tasks are running
- Health Checks will run for over 24 hours even though everything comes back healthy
Any ideas what might be wrong or where to start troubleshooting? It’s almost becoming unusable in its current state.