I have a large SqlServer table with over 400 tables and over 600 SP's and alot of triggers as well.
Recently, it has started giving perfomrance issues, huge memory leaks, heavy CPU usage etc.
I am interested in the following :-
1) Options/costs involved in Load Balancing, and how is this done.
2) Fine Tuning the DB for improving the performance
I have searched articles on the internet but I would also like to hear some expert advise from the gurus here.
Any help would be appreciated.