In many BW Projects, we have seen Basis team and the BW consultants searching around for tracing the regular and best Housekeeping options and activities provided by SAP for improving the performance of BW Production servers.
I have made an attempt to summarize and mention most of the BW House Keeping activities under a single umbrella.
Basically I have divided the activities into 4 parts namely General monitoring, System health monitoring, Performance related monitoring and Occasional activities along with some pure basis activities in the fourth part.
Please find the links to the documents below:
Part 1 can be found here –> http://scn.sap.com/docs/DOC-46602
Part 2 can be found here –> http://scn.sap.com/docs/DOC-46844
Part 3 can be found here –> http://scn.sap.com/docs/DOC-47062
Part 4 can be found here –> http://scn.sap.com/docs/DOC-46965
Hope you will find all the above links useful.
Also, in case if you feel like I have made some mistakes, please feel free to edit them as I have made all these 4 documents as Collaborative ones.
Looking forward for your comments and suggestions.