AdaptiveIndexDefrag - tbl_AdaptiveIndexDefrag_Analysis_log Purging

[mjstrom]

I use usp_AdaptiveIndexDefrag on multiple Sql Server 2016 instances and have noticed that the size of the tbl_AdaptiveIndexDefrag_Analysis_log table grows over time. Most of time the table stays small but there are a few sql instances that have close to 1 GB of data in the table. I am using usp_AdaptiveIndexDefrag_PurgeLogs to cleanup the other log tables but it doesn't purge the data from tbl_AdaptiveIndexDefrag_Analysis_log. Should that table be included in purge procedure?

Thanks

[pvcardoso]

I have corrected that adding to the usp:

DELETE FROM dbo.tbl_AdaptiveIndexDefrag_Analysis_log
WHERE dateTimeStart <= DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), -@daystokeep);