I wanted to ask if it is normal to have such queries on the octopus server and why it is executed so frequently 18000 per min? Our SQL Server is pretty much always 80%
No, this is not normal.
Are you running 2018.2.6 by any chance? If so, you have run into https://github.com/OctopusDeploy/Issues/issues/4324. This was fixed in 2018.2.7.
If not, which version are you running? Also do you have a HA (multi-node Octopus) setup?
that was exactly the problem. After upgrading to the newest release it’s fixed.
Thank you so much!