I prefer to use stored procedures whenever possible to do so. My main reason is for maintenance and tuning. I have an application that do not use SP at all....

Index maintenance is a good idea to fill in the idle CPU.

You need to be careful not to rely on log alone in determining whether the CPU is idle.

Check with...

Your cache hit ratio is pretty low. It should be above 90% at most of the time (mine is around 99% all times with 3 GB memory only). Your memory...