I routinely align my drum tracks manually. The plug ins suggested here look good, and I'm going to investigate them, but it's really not hard to manually align things in time in Sonar.
First, do the alignment
before you do any other editing on the drums. Things can get weird very fast if you've split the tracks (for example) before you try to align them.
I always check to make sure the overheads are timed with each other first. They always are for me, because I use a crossed pair setup for OH. Just look at a clear hit on the OH tracks, zoom way,way in, and make sure that the hit starts at the same time for both OH tracks. If not, drag one of the clips until the start time is the same.
After that, use one of the OH tracks as a guide to line up each of the other tracks, one at a time. E.g. find a snare hit that stands out in the OH track as well as the snare track. Zoom in on the snare tracks along with one of the OH tracks. The wave on the snare track will start earlier than the OH. Just slide the snare track until the two align. Repeat for every track except the room mics.
Sometimes you will see that a waveform will start by going up on the OH track, but start by going down on the individual track. This indicates that the signals are 90° out of phase, or "reversed polarity". Try reversing the polarity on the console strip of the non-OH track. If the two tracks played back together sound more solid, punchier, or thicker with the polarity reversed, leave it reversed. But ultimately, use your ears; reversing the polarity on a track that looks 90° out of phase usually sounds better, but sometimes doesn't make a difference and sometimes sounds worse.
It sounds like a lot of work, but I can do a twelve track drum part in about half an hour. It really sounds better afterward.
If you are actually recording everything in stereo, I would strongly advise switching to mono for everything but the overheads and (maybe) the room mics.