Status of the SPID

• SQLAli

  Ten Centuries

  Points: 1079

  More actions

  December 16, 2013 at 2:57 pm

  #148006

  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………….