The DatabaseFileStatistics in our SQLdmRepository db is getting huge... over 67M rows... that go back to 2016 when we installed the tool.
The DatabaseStatistics table is over 20M.
Is there some purge mechanism that should be running? We are running the Grooming.p_GroomRepositoryData and Grooming.p_GroomRepositoryOrphanData stored procs daily.
Can I just delete some data?
- Martin V.
Had a grooming issue for this table in Version 10.1.4.
Solved it by creating an additional Index on the table.
Passed the information to Idera, but the index did not make it to the current version.