It's often used to describe something loud and disruptive, like:
* Children playing: "The kids are making quite a racket in the backyard."
* A party: "The party was making quite a racket, even from across the street."
* A machine: "The new lawnmower makes quite a racket."
The phrase implies that the noise is unpleasant or bothersome to those around.