Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

rebuilding indexes Expand / Collapse
Author
Message
Posted Friday, October 23, 2009 6:36 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 25, 2011 2:55 PM
Points: 10, Visits: 987
Hi I am trying to rebuild indexes on a database and its taking forever .I am unable to debug
the 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.
Post #807805
Posted Friday, October 23, 2009 6:39 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 9:47 AM
Points: 357, Visits: 914
Have the indexes been created with the ONLINE option set to on?
Post #807808
Posted Friday, October 23, 2009 6:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:31 AM
Points: 2,361, Visits: 6,749
Check if there are blockings.

-Roy
Post #807815
Posted Friday, October 23, 2009 6:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 25, 2011 2:55 PM
Points: 10, Visits: 987
Yes I am basically using a script ,so it is .
Post #807816
Posted Friday, October 23, 2009 6:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 25, 2011 2:55 PM
Points: 10, Visits: 987
Can you please brief it a little more.
Post #807821
Posted Friday, October 23, 2009 6:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:31 AM
Points: 2,361, Visits: 6,749
You can run sp_who2. You will the SPIDS that are blocking

-Roy
Post #807837
Posted Friday, October 23, 2009 7:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 25, 2011 2:55 PM
Points: 10, Visits: 987
I see that its blocked by a process 116
unable to kill the process from activity monitor, any suggestions?
Post #807847
Posted Friday, October 23, 2009 7:13 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 9:47 AM
Points: 357, Visits: 914
What's the error message? Have you tried through query analyser "KILL 116" and seeing what message you get back?
Post #807851
Posted Friday, October 23, 2009 7:15 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:31 AM
Points: 2,361, Visits: 6,749
Can you also provide the script that you used to recreate the index?

-Roy
Post #807854
Posted Friday, October 23, 2009 7:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 25, 2011 2:55 PM
Points: 10, Visits: 987
Hi Roy,
ERROR: Process ID 116 is not an active process.
Post #807877
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse