Octopus deploy database on GENSQL that are honking up memory/resources

Legacy Scale
1

I am editing this post because your website is not allowing me to post a new one.

have 2 queries on in the octopus deploy database on GENSQL that are honking up memory/resources.

It’s affecting the other users on this server
Octopus deploy seems to be querying 2 views extensively… dbo.Dashboard and dbo.deploymentSummary
and those view have nested selects… etc…
lots of index scans…

(@projectid nvarchar(12))
SELECT *
FROM dbo.[Dashboard]
WHERE ([ProjectId] = @projectid)
ORDER BY [Id]

The second query is
(@releaseids_0 nvarchar(14),@releaseids_1 nvarchar(14),@releaseids_2 nvarchar(14))
SELECT *
FROM dbo.[DeploymentSummary]
WHERE ([ReleaseId] IN (@releaseids_0, @releaseids_1, @releaseids_2))
ORDER BY [Id]

OD_tasks.png
OD_tasks.png1379×555 11.8 KB

2

Hi,

Thanks for getting in touch! I’m sorry you’re having this issue. I’ve tested these pages out in Chrome and Firefox, and they load normally for my instance. It’s possibly a browser caching issue, since it works in Internet Explorer. Can you try clearing the cache, and also try accessing these pages in incognito mode and let me know if that helps?

If clearing the cache doesn’t help, can I get some details on your environment to help me more accurately attempt to reproduce this?

  • Which Octopus version are you running?
  • Which Chrome and Firefox versions are you using?
  • Using the developer tools in Chrome and Firefox, do you see any errors in the console tab when trying to load these pages? Can you attach a screenshot if you see errors?

I look forward to hearing back!

Best regards,

Kenny

3

Thanks for the response Kenny. I cleared the cache in chrome and its working again.

4

Hi,

That’s not a problem! I’m glad that did the trick. Don’t hesitate to reach out if you have any further questions :slight_smile:

Best regards,

Kenny

5

The picture attached is for the database issue

OD.png
OD.png856×287 19.2 KB

6

here is another one

od1.png
od1.png1210×276 11 KB

7

Hi!

That’s a bit weird that you can’t add another post. Feel free to reach out to us by email as well: https://octopus.com/support

We are investigating adding some indexes and changing some queries in an upcoming release of Octopus 3. In the meantime we have done some work to reduce load on these two queries as part of Octopus 3.13, and I would recommend upgrading if you haven’t already done so. https://octopus.com/blog/octopus-release-3-13#browser-caching

Hope that helps!
Mike