1) set database to read only during normal opps. Set it to read/write during your monthly update cycle (when other access is disabled) and then back to read only when complete.

2) Get professional help to tune the problematic queries (and mentor you on how to do the same in the future).