• It seems like you are getting regular CPU spikes to 100% every night at about midnight. Is that when your full backups occur? Are you using 3rd party backup compression that has an adjustable compression ratio?

    It seems like your page splits are a little high at the instance level.