Hi,
I have problem with select:
SELECT * FROM dbo.[MultiTenancyDashboard] WHERE ([ProjectId] = @projectid) ORDER BY [Id]
sometimes it takes 20s. Opening project overview takes very long time.
Execution plan suggest to add index on projectId on Deployment table but it dones’t help.
Could you investigate how to speed up view MultiTenancyDashboard
?
I have 25 projects, a few deployments.
Octopus version: 3.11.10
Hi Wojciech,
Thanks for getting in touch! 20s sounds like a long time, even for customers with much larger installations than what you’ve mentioned.
You said you have 25 projects. This particular view is concerned with Deployments
, Releases
and ServerTasks
. Could you run this SQL query so I can get an idea of how many of those records you have?
SELECT COUNT(Id) AS Deployments FROM [Deployment]
SELECT COUNT(Id) AS Releases FROM [Release]
SELECT COUNT(Id) AS Tasks FROM [ServerTask]
One source of a slow dashboard is if you have configured loose retention policies which keep more deployments and releases than necessary. What kind of retention policies have you got configured at the moment? https://octopus.com/docs/administration/retention-policies
Hope that helps!
Mike
Thank’s for your fast response, below my numbers:
Deployments: 2388 (a few :D)
Releases: 1339
Tasks: 2427
Right now my retention policy is: (I think I should change it )
Releases: Keep all
Files on Tentacle: 14 days (sometimes keep all)
Best regards,
Wojtek
Hi Wojtek,
Thanks for keeping in touch! I would recommend setting up your retention policies to an acceptable level and see how that goes. We are looking at how the dashboard scales overall, but in the meantime I believe this will be your best course of action.
Hope that helps!
Mike
Hi,
Thank you very much. Setting correct retention policies resolve the problem.
Discussion could be closed.
Wojtek.