Share via

DPM 2022 no clearing in the database

Alex_Nick 101 Reputation points
2024-10-31T11:01:17.2333333+00:00

HI, everyone,

encountered such a problem as slow execution of tasks, I have a suspicion that the database records are not cleared correctly, checked it with this query

001

how can this be fixed?

use DPMDB --you will need to put in your DPMDB name here
select * from tbl_TE_TaskTrail tt
where datediff (day, tt.stoppeddatetime, getutcdate()) > 33
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,286 questions
Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
1,018 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,030 questions
0 comments
Accepted answer
  1. XinGuo-MSFT 18,771 Reputation points
    2024-11-01T01:15:37.09+00:00

    Hi,

    If the result is 0, garbage collection is working correctly. Otherwise, you can use the following script to manually clean up the tables.

    The Tbl_TE_TaskTrail table is large

    Important

    Back up the database before you run any script against the database.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.