Expensive Queries on SQL Server

performance

(Fabian Trottmann) #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%


(Robert Wagner) #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


(Fabian Trottmann) #3

Hi Robert

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

Thank you so much!