tigertoolbox
tigertoolbox copied to clipboard
usp_AdaptiveIndexDefrag: incorrect duplicate objectId/objectName logged in tbl_AdaptiveIndexDefrag_log
usp_AdaptiveIndexDefrag logs incorrect duplicate objectId/objectName in tbl_AdaptiveIndexDefrag_log during stats update, however corresponding records in tbl_AdaptiveIndexDefrag_Working are fine.
It seems code fails to update @objectName / @objectId variables and inserts the values from the previous object. Usually, it happens when sproc starts updating msdb stats.