We often get asked to help when a magento site has a problem and the overnight tasks take a long time to complete. Above the obvious checks, we also check MySql configs, webserver configs (we prefer to use Nginx), caching engines and hosting environments (many of which we find have often been left at server install default values and can be adjusted to get better performance).