Q

Database reliabilty during the holiday season

Retail systems performance during the holiday season can make or break the relationship VARs have with their retail customers. As the peak season approaches, there are certain aspects of the system that should be fine tuned. Once the season hits VARs should leave them alone.

What strategies can VARs implement for a client who is a retailer and has to keep their system up during the Holiday season?
In the Holiday shopping season uptime and optimal performance are critical. These are a few recommendations that VARs can make to ensure that no system failures occur.

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.

This was first published in January 2007

Dig deeper on Database Management Products and Solutions

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

MicroscopeUK

SearchCloudProvider

SearchSecurity

SearchStorage

SearchNetworking

SearchCloudComputing

SearchConsumerization

SearchDataManagement

SearchBusinessAnalytics

Close