Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Status of the SPID Expand / Collapse
Posted Monday, December 16, 2013 2:57 PM


Group: General Forum Members
Last Login: Friday, July 22, 2016 8:08 AM
Points: 123, Visits: 270
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………….
Post #1523445
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse