xp_availablemedia command hangs. Killing process stuck in rollback.

I was trying to add a file into the tempdb database. When I clicked on the button to open the physical drive, the window did not open. I waited for more than 10 minutes and thought "It's not going to open". So I closed the [add file] window. This hung SSMS. So I close SSMS completely. Then I noticed that the command was running in the background as xp_availablemedia. I tried to kill this process and then the process showed "killed/rollback" and hung there for more than a day. The killing is not progressing. Can anyone explain this to me and provide me with a solution?

more ▼

asked Jun 02, 2016 at 01:27 PM in Default

avatar image

140 5 9 13

This may not be helpful but I saw something similar (not xp_availablemedia) several years ago. A process seemed to be stuck in the killed/rollback limbo (not consuming any resources from what I recall) and it only went away when the SQL Server service was rebooted.

Jul 17, 2016 at 12:14 AM GPO
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 02, 2016 at 01:27 PM

Seen: 79 times

Last Updated: Jul 17, 2016 at 12:14 AM

Copyright 2018 Redgate Software. Privacy Policy