• Sometimes it takes that much time, depending on what it was doing before kill.

    DBCC INPUTBUFFER(SPID) would tell you the current status.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga