I arrived at 7.30 after a troubled nights sleep, there were issues for me to lookinto and sql replication was turned off becuase speed was such an issue. Andrew was called in to do some diagnostic work on it (thankfully because I was totally out of my depth). He found there was a problem with the index missing on one of the tables, one of the IS staff had neglected to create it when the schema was changed, that meant 1.5million records had to be searched each update with no key oops!
Thankfully I and the project plan were vindicated, I still feel I need ot be given a higher level of training or supervisions on upgrads of this importance but thats a topic of conversation for my next review.
No comments:
Post a Comment