Ok, thank you sir, I'll continue to explore this. My primary goal is to minimize the potential impacts to the application using the primary database from my reporting and ad hoc querying. Replication latency of under a minute would be acceptable. I'm sure the ideal scenario is moving this to a different server or perhaps instance but I might not have that luxury.

I'd almost like to allocate server resources on a database by database level but to the best of my knowledge that is not possible. Thanks again.