Missing Indexes

Octopus Server
1

Hi Team,

I upgraded Octopus Server from version “2022.1.2495” to version “2023.2.12482”, after upgrade I noticed a significant issue with memory reservation.
After running “System Integrity” check, we got following error:

"
Missing item: IDX dbo.IX_DeploymentCompletion_DeploymentId DeploymentId
Missing item: IDX dbo.IX_DeploymentCompletion_DeploymentId NONCLUSTERED 0
Missing item: IDX dbo.IX_DeploymentCompletion_SequenceNumber CLUSTERED 0
Missing item: IDX dbo.IX_DeploymentCompletion_SequenceNumber SequenceNumber
Missing item: IDX dbo.IX_DeploymentTargetMetadataInspection_CapturedAt
CapturedAt
Missing item: IDX dbo.IX_DeploymentTargetMetadataInspection_CapturedAt NONCLUSTERED 0
Missing item: IDX dbo.IX_DeprovisionDynamicEnvironmentForProjectTask_BusinessProcess
BusinessProcessState
Missing item: IDX dbo.IX_DeprovisionDynamicEnvironmentForProjectTask_BusinessProcess
LastModified
Missing item: IDX dbo.IX_DeprovisionDynamicEnvironmentForProjectTask_BusinessProcess
NONCLUSTERED 0
Missing item: IDX dbo.IX_DeprovisionDynamicEnvironmentTask_BusinessProcess BusinessProcessState
Missing item: IDX dbo.IX_DeprovisionDynamicEnvironmentTask_BusinessProcess LastModified
Missing item: IDX dbo.IX_DeprovisionDynamicEnvironmentTask_BusinessProcess NONCLUSTERED
0
Missing item: IDX dbo.IX_InsightsReport_SpaceId CLUSTERED 0
Missing item: IDX dbo.IX_InsightsReport_SpaceId SpaceId
Missing item: IDX dbo.IX_Interruption_SpaceIdEnvironmentId EnvironmentId
Missing item: IDX dbo.IX_Interruption_SpaceIdEnvironmentId NONCLUSTERED 0
Missing item: IDX dbo.IX_Interruption_SpaceIdEnvironmentId SpaceId
Missing item: IDX dbo.IX_Interruption_SpaceIdProjectId NONCLUSTERED 0
Missing item: IDX dbo.IX_Interruption_SpaceIdProjectId ProjectId
Missing item: IDX dbo.IX_Interruption_SpaceIdProjectId SpaceId
Missing item: IDX dbo.IX_Interruption_SpaceIdTaskId NONCLUSTERED 0
Missing item: IDX dbo.IX_Interruption_SpaceIdTaskId SpaceId
Missing item: IDX dbo.IX_Interruption_SpaceIdTaskId TaskId
Missing item: IDX dbo.IX_KubernetesTaskResourceStatus_Index_read NONCLUSTERED 0
Missing item: IDX dbo.IX_KubernetesTaskResourceStatus_Index_read SpaceId
Missing item: IDX dbo.IX_KubernetesTaskResourceStatus_Index_read TaskId
Missing item: IDX dbo.IX_ProvisionDynamicEnvironmentTask_BusinessProcess BusinessProcessState
Missing item: IDX dbo.IX_ProvisionDynamicEnvironmentTask_BusinessProcess LastModified
Missing item: IDX dbo.IX_ProvisionDynamicEnvironmentTask_BusinessProcess NONCLUSTERED 0
Missing item: IDX dbo.IX_ServerTask_SpaceIdName HasPendingInterruptions
Missing item: IDX dbo.IX_ServerTask_SpaceIdName Name
Missing item: IDX dbo.IX_ServerTask_SpaceIdName NONCLUSTERED 0
Missing item: IDX dbo.IX_ServerTask_SpaceIdName SpaceId
Missing item: IDX dbo.IX_ServerTask_SpaceIdName State
Missing item: IDX dbo.IX_User_DataVersion DataVersion
Missing item: IDX dbo.IX_User_DataVersion NONCLUSTERED 0
Missing item: IDX Insights.IX_InsightsDeployment_Index CLUSTERED 0
Missing item: IDX Insights.IX_InsightsDeployment_Index CompletedTime
Missing item: IDX Insights.IX_InsightsDeployment_Index EnvironmentId
Missing item: IDX Insights.IX_InsightsDeployment_Index ProjectId
Missing item: IDX Insights.IX_InsightsDeployment_Index SpaceId
Missing item: IDX Insights.IX_InsightsRelease_Index CLUSTERED 0
Missing item: IDX Insights.IX_InsightsRelease_Index ProjectId
Missing item: IDX Insights.IX_InsightsRelease_Index SpaceId
"

Can you please provide a script to create those items? Thanks!

3

Hi Kate,

Thanks for getting in touch! I’m just reaching out here quickly to let you know I’ve responded to your email, including a script to recreate all of these missing indexes. :slight_smile:

Let us know how you go, or if you have any other questions or concerns at all.

Best regards,

Kenny

5

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.