Expensive Queries on SQL Server

Legacy Performance
1

Hello,
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%

queries
queries.bmp726×97 275 KB

2

Hi Fabian,

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?

Rob

3

Hi Robert

that was exactly the problem. After upgrading to the newest release it’s fixed.

Thank you so much!