Poorly designed CRM/CMS/SCM/Call Center System, developed using C#/ASP.NET/MS SQL Server.
The problem I have with this is that the client is using this system in production and is approaching a very busy period. The business is semi-seasonal and this means that it is critical that the system is up during this time. All the above mentioned run from one core database using SQL server and because of ridiculously over complicated/large SQL statements the database sever is taking strain big time.
The server itself is pretty impressive 16GB Ram and 16 core processing power. At the moment this is barely coping. So during the busy period it will fall over. Basically there is no time to programmatically correct the problem. We need to chuck hardware at the problem.
This brings me to my question, to implement SQL load balancing do I need to get some development work done or is there a way to load balance without doing any development? The ISP that hosts the server advised that we will need to do some development.