What does need more cowbell mean?

This is a joke from an old Saturday Night Live skit - they were recording a song and one guy kept saying "It needs more cowbell" because he played the cowbell in the band.