Thanks for the responses.

Anthony.green, yes, the reports have to be as close to real time as possible at this point. We are going through the process of identifying reports that can use stale (data from the day before) vs. real time. A transition on that front is not in the near term. Snapshots do not fulfill the real time requirement at this point but it is something I am interested in pursuing once we can identify reports of which the data requirement fall into a day behind model.

Happycat59, I am interested in inserting "SET TRANSACTION ISOLATION LEVEL SNAPSHOT" into the t-sql of individual reports, but what would the practical pros and cons be for turning it on server wide, say less blocking but more pressure on tempdb? Any more advice has to how to change the way replication uses transactions?

Thanks again,

DK