Do you use Sonar Platinum? If so, you have Addictive Drums as part of your package. That certainly comes with overheads.

I have sonar professional

I stopped using Session Drummer when we got AD2 with Sonar. It sounds a lot more real and a big part of that sound is the miking options. Take AD2 and turn off the overheads and/or Room mikes and it will now sound like Session Drummer. 
I will still use SD3 when I need to play my own samples. That is what is missing from AD2.