Index Rebuild on DB configured with Mirroring

Hi,

Can we rebuild indexes ONLINE on Primary DB configured with Mirroring ? Does it impact mirroring process by any chance ? Do we have any consequences in doing this ? Also can we check the fragmentation info using DBCC SHOWCONTIG with out any impact on this ?

Could some one give me a clear picture here??

Thanks
parpaaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dbaSQLCommented:
yes.  
>>Rebuilding an index takes longer with safety FULL than it does with safety OFF. Synchronous mirroring introduces more overhead when rebuilding a clustered index than when rebuilding a nonclustered index. Figure 2 illustrates the index rebuilding time for a clustered and a nonclustered index for various safety levels. Figure 2 also compares the performance of ONLINE and OFFLINE index rebuilding for various safety levels. During an ONLINE index rebuild, the table and the index are available for queries and data modification, whereas during an OFFLINE index rebuild, a table lock is acquired and no other operation on the table is allowed.

see here:
http://www.sqlskills.com/blogs/paul/post/More-on-Database-Mirroring-performance-and-index-maintenance.aspx

and here:
http://technet.microsoft.com/en-us/library/cc917681.aspx

in all cases, the maintenance action on the mirrored db is going to impact performance, and the runtimes are likely to be longer than doing the same, on the non-mirrored database.  regardless, it can be done.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
parpaaAuthor Commented:
Thanks dbsQL :)

This is very helpful
0
parpaaAuthor Commented:
Helpful
0
dbaSQLCommented:
No problem at all, parpaa.  I'm glad to have been able to help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.