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

The problematic query is this:

Query ID 96222:
(@LowerBound int,@UpperBound int)SELECT [Id],
FROM [dbo].[Emails]
WHERE [Id] >= @LowerBound
AND [Id] < @UpperBound

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

    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