InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 03:15:06 GMT20http://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxAfter being bitten by the blocking bug in the past where the index rebuild jobs were blocked by a connection from the application that wasn't closed, I implemented a standard practice to include a lock time out in my script that rebuilds the indexes: SET LOCK_TIMEOUT 900000; -- Set it to 15 minutes to avoid causing blockingSo now instead of the index rebuild job being blocked, it just times out after 15 minutes and moves on to the next index.Fri, 23 Oct 2009 11:12:06 GMTGeorge M Parkerhttp://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxThat means that by the time you went to kill it 116 was already finished. How many rows does the table have? When you run the command sp_who2, what is the status of the create index spid? Also please provide the script that you used for recreating index.Fri, 23 Oct 2009 07:37:30 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxHi Roy,ERROR: Process ID 116 is not an active process.Fri, 23 Oct 2009 07:34:58 GMTCharith12345http://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxCan you also provide the script that you used to recreate the index?Fri, 23 Oct 2009 07:15:19 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxWhat's the error message? Have you tried through query analyser "KILL 116" and seeing what message you get back?Fri, 23 Oct 2009 07:13:21 GMTNickBalaamhttp://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxI see that its blocked by a process 116unable to kill the process from activity monitor, any suggestions?Fri, 23 Oct 2009 07:07:00 GMTCharith12345http://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxYou can run sp_who2. You will the SPIDS that are blockingFri, 23 Oct 2009 06:56:23 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxCan you please brief it a little more.Fri, 23 Oct 2009 06:46:51 GMTCharith12345http://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxYes I am basically using a script ,so it is .Fri, 23 Oct 2009 06:43:25 GMTCharith12345http://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxCheck if there are blockings.Fri, 23 Oct 2009 06:43:14 GMTRoy Ernesthttp://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxHave the indexes been created with the ONLINE option set to on?Fri, 23 Oct 2009 06:39:47 GMTNickBalaamhttp://www.sqlservercentral.com/Forums/Topic807805-146-1.aspxHi I am trying to rebuild indexes on a database and its taking forever .I am unable to debugthe issue. Before 2 months it usually takes around 47 min by my past 2 attempts are failure.Last time it took more than a day so I got to abort the job an at yesterday I initaited the job at 11.00pm an I see its still running. can you please let me know how to solve this problem???????I would appreciate your response...........I am in a bit of crises..........Performance is bad.Fri, 23 Oct 2009 06:36:45 GMTCharith12345