I don't get sweats from tramadol, but I have gotten them from lots of other meds. The other thing that gave me sweats was menopause.
You might try the extended releast tramadol for evening. It doesn't give the mood elevation or as good pain relief as the instant release, but it doesn't keep me awake either.
I take Ambien to get off to sleep, and with the small amount of nighttime pain relief I can at least go back to sleep when I wake up during the night. Ambien acts very quickly but doesn't last very long. You take it just as you are hopping into bed. There's no hangover in the morning.