tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

AdaptiveIndexDefrag - tbl_AdaptiveIndexDefrag_Analysis_log Purging

Open mjstrom opened this issue 6 years ago • 0 comments

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

mjstrom avatar Jul 24 '19 18:07 mjstrom