Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Status of the SPID Expand / Collapse
Author
Message
Posted Monday, December 16, 2013 2:57 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 8:37 AM
Points: 115, Visits: 235
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:
status percent_complete estimated_completion_time
running 0 0


Thanks,
I’m nobody but still I’m somebody to someone………….
Post #1523445
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse