We host our own Octopus server on a VM on Azure using Azure SQL.
The system has been running very slow and it appears the following query is running constantly on the SQL database, consuming all our DTU’s allocated:
(@docid nvarchar(21))SELECT COUNT(*)
WHERE ([RelatedDocumentIds] LIKE @docid)
What is going on? I’m rebooting the server now to see if that clears it.