Friends,
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.
Output:
statuspercent_completeestimated_completion_time
running00
Thanks,
I’m nobody but still I’m somebody to someone………….