http://moodle.org/mod/forum/discuss.php?d=57028
If you have a testing server with same hardware/software configuration, you might want to try this script, it would tell you whether your DB server is under-powered or not. In general adding more RAM to the DB server would be a good idea. Hope this helps...