Every 10 PM EST a process runs on azure sql that would cause the system to slow, any idea what that would be?

AA 1 Reputation point
2022-07-11T14:43:28.527+00:00

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?

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,706 Reputation points MVP
    2022-07-11T15:06:52.113+00:00

    Based on this MIcrosoft Support article this may be related to scheduled export of Azure SQL Databases as bacpac to maybe Azure Storage.

    0 comments No comments