From the graphs I see high CPU, low PageLifeExpectancy, and high Compilations.  All these happen when doing a table Rebuild or REINDEX or Auto Update Statistics.

I  would do something very simple such as logging all sysprocesses every minute for a day and comparing processes just before, during, and after the event.