Thanks everyone. All good now. There was one particular index that needed some TLC. Also sized the log appropriately and set its autogrow to an appropriate value. It was set at the 10% default.

Thanks Again!