Hi everyone,
the database of Orchestrator has had a peak in DTU (100%) for days, continuously, then it returned to the normal situation without doing anything.
The query that was impacting the DTU for hours and hours was the following one:
(@DynamicFilterParam_000007 bigint,@DynamicFilterParam_000009 int,@DynamicFilterParam_000003 bit,@p__linq__0 bigint)SELECT
[Extent1].[Id] AS [Id],
[Extent1].[TenantId] AS [TenantId],
[Extent1].[OrganizationUnitId] AS [OrganizationUnitId],
[Extent1].[Key] AS [Key],
[Extent1].[StartTime] AS [StartTime],
[Extent1].[EndTime] AS [EndTime],
[Extent1].[State] AS [State],
[Extent1].[RobotId] AS [RobotId],
[Extent1].[ReleaseId] AS [ReleaseId],
[Extent1].[Source] AS [Source],
[Extent1].[StartingScheduleId] AS [StartingScheduleId],
[Extent1].[BatchExecutionKey] AS [BatchExecutionKey],
[Extent1].[Info] AS [Info],
[Extent1].[Type] AS [Type],
[Extent1].[InputArguments] AS [InputArguments],
[Extent1].[OutputArguments] AS [OutputArguments],
[Extent1].[HostMachineName] AS [HostMachineName],
[Extent1].[PersistenceId] AS [PersistenceId],
[Extent1].[ResumeVersion] AS [ResumeVersion],
[Extent1].[SuspendBlobType] AS [SuspendBlobType],
[Extent1].[PersistenceLocationVersion] AS [PersistenceLocationVersion],
[Extent1].[StopStrategy] AS [StopStrategy],
[Extent1].[ReleaseVersionId] AS [ReleaseVersionId],
[Extent1].[IsDeleted] AS [IsDeleted],
[Extent1].[DeleterUserId] AS [DeleterUserId],
[Extent1].[DeletionTime] AS [DeletionTime],
[Extent1].[LastModificationTime] AS [LastModificationTime],
[Extent1].[LastModifierUserId] AS [LastModifierUserId],
[Extent1].[CreationTime] AS [CreationTime],
[Extent1].[CreatorUserId] AS [CreatorUserId]
FROM [dbo].[Jobs] AS [Extent1]
WHERE (([Extent1].[OrganizationUnitId] = @DynamicFilterParam_000007) OR ( CAST( [Extent1].[OrganizationUnitId] AS bigint) IS NULL) ) AND (([Extent1].[TenantId] = @DynamicFilterParam_000009) OR ( CAST( [Extent1].[TenantId] AS int) IS NULL) ) AND (([Extent1].[IsDeleted] = @DynamicFilterParam_000003) ) AND ([Extent1].[RobotId] = @p__linq__0) AND (1 = [Extent1].[Type]) AND ((1 = [Extent1].[State]) OR (2 = [Extent1].[State]) OR (3 = [Extent1].[State]))
Do you know what this query is due to?
Thank you!