• Yes, we are only using selects in our reports, but the selects are complex with large predicates, mostly ad-hoc, with wide spread use of CTEs(With;) statements and unions. Yes, we have most all of the columns used in the reports covered with indexes. The blocking occurs through read locks on high volume tables, tables that are being inserted into frequently on the publisher side and are being read from frequently on the subscriber side.

    Thanks,

    DK