This skit is famous. Wikipedia says (here) it’s “considered one of the greatest SNL sketches ever made, and … is often placed in the top ten, being ranked number nine by Rolling Stone. As a result of its popularity, ‘more cowbell’ became an American pop culture catchphrase, and has even entered the dictionary.” For the backstory, watch this video.