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

Rebuild Index Expand / Collapse
Author
Message
Posted Thursday, January 20, 2011 12:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 12:23 AM
Points: 250, Visits: 745
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
Posted Thursday, January 20, 2011 11:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 7:59 PM
Points: 1,194, Visits: 2,222
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
Posted Thursday, January 20, 2011 9:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 12:23 AM
Points: 250, Visits: 745
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
Posted Thursday, January 20, 2011 9:40 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:17 AM
Points: 13,867, Visits: 28,265
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 Query Performance Tuning
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
Posted Friday, January 21, 2011 7:57 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:19 AM
Points: 4,399, Visits: 6,255
ravisamigo (1/20/2011)
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.


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 »

Add to briefcase ««12

Permissions Expand / Collapse