question

Rafal.Stolzman avatar image
Rafal.Stolzman asked

Closing Rebuild Indexes window

I tried to rebuild indexes on a large table from SSMS RC Table->Indexes->Rebuild All. the PK index rebuild failed while others succeeded. This was due to insufficient disk space in Primary file group. The disk was almost full, I made 45GB by moving a backup file. Four days later the Rebuild Indexes window still says "Executing" (Please see attached screenshot)![alt text][1] and so I get a warning when trying to exit the SSMS "Closing this application may terminate this process: Rebuild Indexes". How can I tell if the rebuild indexes process has completed and if I can close this window. Is there anything I should do look for here? [1]: /storage/temp/3174-rebidxwin.jpg
indexingrebuild
rebidxwin.jpg (118.6 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
I suspect the process is already dead, just that the window doesn't recognize it. However, to be sure, you can run a query against sys.dm_exec_requests to identify any outstanding processes that are running, or locked, blocked, waiting on a task. That's the best way I know to check on the status of operations within the system. You might need to join to sys.dm_exec_sql_text in order to see the queries. If you do a search on these DMVs, you'll get lots of examples.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rafal.Stolzman avatar image Rafal.Stolzman commented ·
Thanks Grant so how can I tell that it's running vs it's safe to kill?
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
If it's active, you'll see wait states, etc. If it's blocked, you'll see that. If it's just sitting there, it's safe to kill, but it might still suffer from a rollback, so be cautious there.
0 Likes 0 ·
Rafal.Stolzman avatar image Rafal.Stolzman commented ·
OK great thanks for help. I've killed the process and it looks fine.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.