October 19, 2005 at 9:50 am
Found the problem which is causing new jobs to hang.On saturday evening we are running a reindex on our database. But a client has disconnected the day before, but his session is still hanging on the SQL server .So now I've the following.
SPID 113 SP_EXECUTE;1 "Tablename"
SPID 57 (Blocked by 113) DBCC DBREINDEX "Tablename"
SPID 10 (Blocked by 57) Autoshrink
So it seems my reindex never ended, eventhough it was stopped via the sql server agent.So which process shall I kill first? And what will happen to my reindex, will it be rolled back (all the way?) and then causing the Transaction log to be filled? (The reindex was done under Bulk-logged recovery whereas the databse is now in Full recovery mode) ???
October 21, 2005 at 3:22 am
Please paste here what the step1 does ?
Jayesh
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply