Point Connection String to custom utility

Hi All, Im wanting to know if there is a way I can point our connection string to a custom application/utility.

The reason being we currently are running an asp mvc LOB application which is having some performance issues with some of our bigger customers because they are running large reports and kpi's from the application during peak times which is causing everyone to slowed down. Delaying these reports and kpis is not an option so we are replicating the db to another server and I want to pass the bigger read only data calls to it.

Without changing the application code (because 95% of our customers dont come across this problem) I am hoping we can point our current connection string to a custom node that will analyse the data call and decide whether it should be sent to the main server if it is mission critical and whether is should be sent to the secondary data server if it is a read only query.

Can anyone give any advice on if this is doable and if so where to start?

Thanks in advance

1 answer