I work on Solaris, so i can´t address Windows issues.

As far as MTS goes, it is not a cure all. It works well if transactions are short. Reports or long running query can tie up your resources and prevent all but a few users from getting any resources.