microsoft / tigertoolbox

Toolbox repository for Tiger team
http://aka.ms/sqlserverteam
Other
1.45k stars 734 forks source link

usp_AdaptiveIndexDefrag: incorrect duplicate objectId/objectName logged in tbl_AdaptiveIndexDefrag_log #288

Open miksh7 opened 1 year ago

miksh7 commented 1 year ago

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.