Only sedation helps a bit with pain

Is that a bad sign? I tried many painkillers and muscle relaxer and nothing. What could be the problem if only sedation helps a bit my tension headache?