Home Forums SQL Server 2016 SQL Server 2016 - Administration Publisher performance - transactional replication RE: Publisher performance - transactional replication

  • April 24, 2018 at 2:28 am

    #1987978

    andreas.kreuzberg - Tuesday, April 24, 2018 1:42 AM

    I have not made any changes to indexing on the subscriber/distributor - I only add/remove/maintain indexes on the publisher

    Hm,
    but if you rebuild an index, the new index will be published. I knew index with a size about 200 GB. Please check the size of the index. How to you made index maintenance, with scripts vom ola hallengren, or do you rebuild every index every night?
    Best regards,
    Andreas

    Of the 27 databases, the biggest index is 25 GB. Other databases's biggest index values varies from 10 GB or smaller
    I have not seen the script from hallengren you are referring to, but I maintain my indexes each night with a script that checks the fragmentation - it rebuilds or reorganizes based on the fragmentation value. If it is not fragmented I do nothing to it