I have executed the update stats on 4 TB Database and when i check the status of the SPID it shows 0. It is not at all showing the percentage completion when i checked with sys.dm_exec_requests. Is there any alternate procedure to check the status of the SPID.
Note: It is updating the statistics on the objects without issues.
status percent_complete estimated_completion_time
running 0 0
I’m nobody but still I’m somebody to someone………….