Share via

Backup cost too much DTU for my azure sql database

HuJiaJun(Cary) 20 Reputation points
2025-01-06T01:28:42.1366667+00:00

Hi Community,

Recently, We noticed the SQL data base DTU has been High for a long time:

enter image description here

We noticed the activity log shows there is an anonymous user exports exist database every week:

enter image description here

What is that? Is the database backup action? How can I reduce the DTU usage?

Thanks, Cary

Azure SQL Database
Accepted answer
  1. Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator
    2025-01-07T09:29:22.6833333+00:00

    Hi @HuJiaJun(Cary)

    I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

    Issue:

    Recently, We noticed the SQL data base DTU has been High for a long time:

    enter image description here

    We noticed the activity log shows there is an anonymous user exports exist database every week:

    enter image description here

    What is that? Is the database backup action? How can I reduce the DTU usage?

    Solution:

    The problem is our marketing team is running some scan for the site, so the database cost too much.

    Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
    2025-01-06T10:07:49.94+00:00

    My gut feeling says that this is not the backup scheduled by the service. Also, I am not sure that it is the export operation that is the culprit for the high DTU consumption. The export only runs once a week, and there is not really a correlation to your DTU curve.

    But there is one piece of information missing: for how long time does the export operations run? The image suggest that you can expand the lines to get more information.

    1 person found this answer helpful.
    0 comments
  2. Adharsh Santhanam 6,020 Reputation points Volunteer Moderator
    2025-01-06T04:06:45.1533333+00:00

    Hello HuJiaJun(Cary), high DTU usage can be caused by various factors such as the size of your database, the complexity of your queries, or the service tier you are using. It's essential to identify which resource (CPU, memory, I/O) is contributing to the high usage. You can query the sys.dm_db_resource_stats table to get insights into resource usage. The activity log showing an anonymous user exporting the database every week could indicate a scheduled backup or export operation. Azure SQL Database provides automated backups for point-in-time restore (PITR) and long-term retention (LTR). These backups are crucial for disaster recovery and data protection.

    Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

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.