The diarrhea and cold sweats are the side effects i have. when can i expect total relief?

Depends: It depends on the cause or source. If medication, it needs to flush from your system - each medicine has it's own halflife of clearnace from the body. In some cases, if the med causes a heart rhythm issue, it may not get better and may worsen. Same thing goes for antibiotics - they may induce c-diff colitis and symptoms will not improve. If not improving, seek evaluation and further care.