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?