3,2,1… What Should Be Taken Into Consideration Before You Start Your Maintenance Cycle?
Do We still need maintenance windows to keep our access paths in order? How you can start planning your maintenance windows? How to discover risks with data model limitations? In presentation is also discusses process of rebinding plans/packages after the reorganisation and RUNSTATS. Few words about missing or conflicting statistics.
How to maintain pending changes and make maintenance windows working for you in terms of better performance, availability, … ? Which utilities should be automated and composed in „blocks”. ?