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....