What is the meaning of the idiom as sick as a dog?

It refers to being extremely sick. The idiom compares a human's very uncomfortable illness (like the flu or a bad virus) with how ill a dog gets when it eats something it is not supposed to eat and often gets a very severe reaction.