tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

usp_AdaptiveIndexDefrag: incorrect duplicate objectId/objectName logged in tbl_AdaptiveIndexDefrag_log

Open miksh7 opened this issue 2 years ago • 0 comments

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.

miksh7 avatar Nov 29 '22 19:11 miksh7