As well as a way of saying extreme pain and pleasure, which refers to the practises of BDSM, The Agony and Ecstasy is the title of a 1961 novel by Irving Stone about the life of Michelangelo, which was made into a film in 1965.
from Curves and Nerves