Can some please explain to me what happened to Sherlock Holmes a study in scarlet?

i cant understand it. i fell a bit unsatisfied with the conclusion. what happened? what was the motive? was the word Rache used only to confuse the police? didnt it mean anything more than that?