1. Steve had to have two alarm clocks set to wake him up because one was never loud enough. He slept like a log.
2. As a rule, the baby never wakes up during the night. She sleeps like a rock , and even the noise of the TV doesn’t wake her.

The expression suggests that it is as difficult to wake such a person as it would be to wake a log or a rock.