Do Azure SQL backups get included in DTU limits?

Mark Harrison 6 Reputation points
2020-09-15T08:57:15.087+00:00

Can anyone tell me if an azure SQL backup operation could contribute as part of a database's DTU limit? I have a DB that frequently hits its max DTU every 12 hours or so, which seems suspiciously like a backup operation.

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,191 Reputation points
    2020-09-15T13:57:38.153+00:00

    Good day,

    As you can see in this document, Azure database creates full backups every week, differential backups every 12-24 hours, and transaction log backups every 5 to 10 minutes.

    This fit your description if the differential backups is actually done every 12 hours.

    I have a DB that frequently hits its max DTU

    unexpected performance might occur when full/differential backup running. Execute the following query when the issue appears: 

    SELECT   
 r.command, query = a.text, start_time, percent_complete,   
 eta = dateadd(second,estimated_completion_time/1000, getdate())  
FROM sys.dm_exec_requests r  
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a  
WHERE r.command IN ('BACKUP DATABASE','BACKUP LOG')

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.