I've only been here for a few days, and I have already noticed a
large issue with users running queries that may take several hours,
without any notification to other users of the tools server, often
resulting in replication lag. While notifying the users of the tools
server will not exactly be a big help, a query that is intended to
take up a large chunk of time could be shown to users of the tool
server for help with any possible optimizations that may result in
speed increases with your query. As well, a query can be
strategically placed to run at times when the tool server is at low
activity (possibly during the night.)
Just a thought.
TDS
tds(a)cloudstormtech.com