Tasks page and api taking too much time to load

[Naman.Kumar]

Upgraded Octopus Deploy to 2023.1 and tasks load time has increased since then. taking over a minute to load the page

[sean.stanway]

Hi @Naman.Kumar

This may be missing indexes if you recently did an upgrade and it’s taking a long time to load.

Could you perform a system integrity check for me on your server? You can do this by going to Configuration > Diagnostics and selecting the option at the top. If you could send the full results log over, we can take a look.

Kind Regards

[Naman.Kumar]

Result:
Task ID: ServerTasks-2240577
Related IDs:
Task status: Failed
Task queued: Tuesday, 18 April 2023 9:26:47 AM +00:00
Task started: Tuesday, 18 April 2023 9:27:00 AM +00:00
Task completed: Tuesday, 18 April 2023 9:27:00 AM +00:00
Task duration: less than a second
Server version: 2023.1.9788
Server node: XXXXX

                | Failed: Check System Integrity

09:27:00 Error | Schema… [ Failed ]
09:27:00 Info | Release channel belongs to the appropriate project… [ Passed ]
09:27:00 Info | Orphaned tenanted deployments… [ Passed ]
09:27:00 Info | Orphaned channels… [ Passed ]
09:27:00 Info | Orphaned releases… [ Passed ]
09:27:00 Info | Only one unfrozen deployment process per project… [ Passed ]
09:27:00 Fatal | One or more data errors were found.
|
| Failed: Schema
09:27:00 Error | Unexpected item: VIEW dbo.Dashboard_ms.CompletedTime datetimeoffset(10/34/7) 1
| Unexpected item: VIEW dbo.Dashboard_ms.Created datetimeoffset(10/34/7) 0
| Unexpected item: VIEW dbo.Dashboard_ms.CurrentOrPrevious varchar(1/0/0) 0
| Unexpected item: VIEW dbo.Dashboard_ms.EnvironmentId nvarchar(100/0/0) 0
| Unexpected item: VIEW dbo.Dashboard_ms.ErrorMessage nvarchar(-1/0/0) 1
| Unexpected item: VIEW dbo.Dashboard_ms.HasPendingInterruptions bit(1/1/0) 0
| Unexpected item: VIEW dbo.Dashboard_ms.HasWarningsOrErrors bit(1/1/0) 0
| Unexpected item: VIEW dbo.Dashboard_ms.Id nvarchar(100/0/0) 0
| Unexpected item: VIEW dbo.Dashboard_ms.ProjectId nvarchar(100/0/0) 0
| Unexpected item: VIEW dbo.Dashboard_ms.QueueTime datetimeoffset(10/34/7) 0
| Unexpected item: VIEW dbo.Dashboard_ms.ReleaseId nvarchar(100/0/0) 0
| Unexpected item: VIEW dbo.Dashboard_ms.State nvarchar(100/0/0) 0
| Unexpected item: VIEW dbo.Dashboard_ms.TaskId nvarchar(100/0/0) 1
| Unexpected item: VIEW dbo.Dashboard_ms.Version nvarchar(698/0/0) 0
|

[sean.stanway]

Hi @Naman.Kumar

It looks like there is some indexes that are not recognised by Octopus as our indexes, but don’t see how they would affect the page and API loading. Is this a custom view that you have added? If you’re unsure why it is there it may be worth removing, otherwise it can be left.

Would we be able to get a index fragmentation report from the Octopus database?
Can you also send over the latest Octopus Server log? It should have response times.
Generating a HAR file with the slow loading would also be good.

Since this is a public forum you can upload all the files to our secure repository here: Support Files - Naman Kumar

Kind Regards
Sean