February 11, 2009 at 4:16 pm
I recently setup a reporting database using transactional replication. Everything was fine until I realized that performance is getting pretty bad on the reporting database (the subscriber). I used dbcc showcontig to check the indexes on the subscriber and they need help! So, obviously my index maintenance on the the publisher doesn't get replicated to the subscriber.
Is it going to hurt my replication to run index maintenance on the subscriber?
Is there any way to get my index maintenance commands to replicate? I currently use a script on the publisher to selectively execute dbcc dbreindex.
Thanks
May 20, 2009 at 6:06 am
:-):-D:-P;-):w00t::cool::hehe::blush::smooooth:
May 20, 2009 at 6:06 am
:-):-D:-P;-):w00t::cool::hehe::blush::smooooth:
May 21, 2009 at 1:17 pm
You have to run index maintainance plane on subsciber as well....
also for reporting performance porpose you can add/ chage the index on subsciber index on
HTH.
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply