For the great Servus Servorum Dei.
Almighty and everlasting God, the eternal salvation of those who believe, hear us on behalf of Your servant who is sick, for whom we humbly ask the help of your mercy, that, being restored to health, he may render thanks to You in Your Church. Through Christ our Lord. Amen.
Or, if this is his time:
Almighty and merciful God, You bestow on mankind both the remedies of health and the gifts of everlasting life. Look graciously on Your servant suffering from bodily infirmity, and strengthen the soul which You have made. At the hour of his death may he deserve to be offered without stain of sin to You his Creator by the hands of the holy angels. Through Christ our Lord. Amen.
[--Both taken from the Catholic Prayer Book of Fr. John A. Hardon, S.J.]