Based on this MIcrosoft Support article this may be related to scheduled export of Azure SQL Databases as bacpac to maybe Azure Storage.
Every 10 PM EST a process runs on azure sql that would cause the system to slow, any idea what that would be?
The problematic query is this:
Query ID 96222:
(@LowerBound int,@UpperBound int)SELECT [Id],
DATALENGTH([Filename]),
[Filename],
DATALENGTH([Base64Data]),
[Base64Data]
FROM [dbo].[Emails]
WHERE [Id] >= @LowerBound
AND [Id] < @UpperBound
ORDER BY [Id] ASC
The issue happens every day and it isn't part of our application. We can't seem to find the problem.
Notice that the issue is because of datalength in the query that's causing the problem. The table contains data and is large, we don't want this query to run. Any ideas on what this is about?