Database Standard Operations List
1. DB Development standard
l Database is only a storage , do not depend too much on database
l Build a standard workflow for who ,when , how regarding different object levels
l Make a standard permission control for who should have which right
l Training and let all know who is the right person(dba, leaders) when they have any problem
2. Data Performance Collection standard
l Make sure it does not impact db performance too much or impact other business
l Make sure that only use one or two collection platform
l Make sure the collection schedule is reasonable
l Make sure the collected is real useful
l Make sure it’s easy configured and managed (disable ,enable)
3. Data Report standard
l Automatically report standard
ü Build standard for what , how ,when, who for daily report , weekly report and monthly report
ü Make sure it is real useful info and they have time to handle
ü Make a tracking for each report and make sure it is improved
l Manually report standard
ü Analyze historical info then improve our performance in high level
ü Make sure dba and ops to find a solution together then improve it
4. DB Enhancement standard
l Make sure enhanced plan is prepared ready ,before do anything
l Make sure the enhancement solve our problem really and has the compared list between before and now
5. Disaster recovery
l Make sure every solution we have tested more and it has loged what happen