Thank you, Grant, I appreciate the response.

Thanks Steve.

Thank you.

I am wondering what others have used as a solution for offloading read-only tasks to a read-only replica in the availability group.

We have roughly 5,000 procedures and about...

Thanks Craig.

Thanks.

That is exactly what the current process is doing. I was just trying to explore other options to see if there is anything better out there.

Thanks Lowell!

Thank you both, really appreciate it.

Thanks everyone.

I was looking for something like Shared Databases but not read only.

Now I know better.

Yes.

I would imagine a sort of controller that would accept the connections and point them to the correct server on the back end.

Thanks, I wasn't even thinking of a non-code changing solution.