Most major retail outlets should go into a lock down mode just prior to the Holiday season. All development ceases weeks before and patches deployment is deferred until the Holiday season is over. Nothing new is added to the system which might result in any downtime or performance degradation. This ensures that any bugs should have manifested themselves prior to the lockdown period and have been fixed, and no new bugs have being introduced by new development.
Prior to the Holiday season, VARs should tune the database as much as possible for optimal performance. This involves:
- Updating your indexes and disable automatic updating of statistics.
- Archive off any data which is not essential for the current application requirements. For example, move any historical data to a data warehouse.
- A prophylactic restart in the days before the peak season hits is a wise idea to clear any memory leaks.
The failover system is verified and tested to ensure that should the system go offline the failover solution will be reliable with a minimum of downtime and data loss.
Dig Deeper on Database Management Products and Solutions
Related Q&A from Hilary Cotter
Learn the new components of Windows XP SP3 including black hole router detection and network access protection. Compare XP SP3 features to Vista and ...continue reading
Learn why Oracle VM would be chosen over Hyper-V or VMware and read an expert's recommendations for implementing Oracle VM.continue reading
SOA depicts how two services or programs can communicate with each other. Learn why SOA should catch the attention of service providers and the ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.