Former Manchester City defender Michael Tarnat believes Pep Guardiola's struggles as Manchester City manager are over.