Rebuild Index

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Rebuild Index

15 posts, Page 2 of 2

««1 2

Rebuild Index

Rate Topic

Display Mode

Topic Options

Author

Message

ravisamigo

Posted Thursday, January 20, 2011 12:56 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

Sorry for the late reply.

Thanks of your valid suggestions and help !!

Is there any impact to database if we do the index rebuild simultaneously/parellely except the performance issue means database goes to suspect mode or...?please

Please advise me on this.

Thanks and Regards,
Ravi.

Post #1050550

sqlbuddy123

Posted Thursday, January 20, 2011 11:14 AM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 3:17 PM
Points: 715, Visits: 1,524

It should be fine except for the clustered indexes. But please test it on the test machine before implementing.

Thank You,

Best Regards,
SQLBuddy

Post #1051035

ravisamigo

Posted Thursday, January 20, 2011 9:12 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

Thanks for the reply.

But we don't have testing environment to test this.

Please advise whether it's fine to proceed or any impact to database.

Regards,
Ravi.

Post #1051304

Grant Fritchey

Posted Thursday, January 20, 2011 9:40 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 13,383, Visits: 25,187

You should be testing anything new before you do it on your production database. No development environment or anything. You're developing straight onto production? That's very dangerous. I sure hope your backups are extremely well maintained. I won't ask if they're tested.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1051314

TheSQLGuru

Posted Friday, January 21, 2011 7:57 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 12:01 PM
Points: 3,582, Visits: 5,130

ravisamigo (1/20/2011)

1) Unless you are on the Enterprise Edition and use the ONLINE option, rebuiding an index will exclusively lock that table and prevent ANY access to it while the index is being rebuilt. So you can completely shut down your application if you rebuild important tables.

2) assuming your IO is on the same spindles for these tables then yes you can seriously affect IO throughput with index maintenance. They can also hammer CPU usage as well.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail

Post #1051561

« Prev Topic | Next Topic »

15 posts, Page 2 of 2

««1 2

Permissions