In relations with sleep deprivation and insomnia what medications can be beneficial to the patient when they are having trouble sleeping and or not sleeping at all.

If the patient is sleep walking should they be taking any tranquillisers as a medication.

How can I support some-one that has similar problems or if their conditions are getting progressively worse quickly, what should I do?