Black Friday has been an American tradition for decades. Today, along with Cyber Monday, Black Friday is a worldwide marketing juggernaut. And retail analysts are expecting the 2017 edition to set new records.
The National Retail Federation estimates that 69% of Americans — around 164 million people — are planning to shop either online or in person during the U.S. Thanksgiving weekend. In fact, it’s anticipated that one out of every six dollars this holiday season will be spent between Thanksgiving and Cyber Monday, generating $19.7 billion in sales. Adobe forecasts total online sales this holiday season of $107.4 billion, an increase of 13.8% over 2016. And Adobe also predicts that this Cyber Monday will be the largest online shopping day in history, delivering $6.6 billion in sales (and topping last year’s figures by 16.5%).
To help your organization stay ready, our experts have compiled their Top 7 Tips for keeping your databases running smoothly:
- Review performance metrics from last year, forecast this year’s consumption, and then load test based on those numbers
- Pull the trends from last year’s holiday shopping weekend. Trends should include the number of transactions/second, throughput, application and disk response time, batch requests/second, CPU, and memory utilizations
- Forecast the current year’s load based on last year’s consumption
- Assess whether the hardware can bear the forecasted capacity
- Perform load testing on the servers, simulating the point-of-sale transactions
- Adjust hardware based on the testing results
- Evaluate backup and failover strategy, and perform disaster recovery testing
- Ensure your backup strategy is proper and in place. We also recommend having a redundant copy of your backup on an external storage device or in a data center
- Ensure backups can be restored efficiently when needed
- Perform a dry run of your backup and restore procedure
- Perform disaster recovery (DR) testing to ensure your system runs properly on the DR server
- Perform server health check and configuration check
- Perform an overall health check of your database server
- Ensure memory, NIC cards, and hard disks are all healthy
- Ensure power connectivity and power backups are in place
- Perform a database configuration check: Look for common configurations, make sure memory settings are accurate, and ensure threads, parallelism, and other settings are per the hardware
- Test high availability solution and perform connection pooling for estimated traffic
- The database server should be able to manage the estimated number of incoming requests during peak traffic times. Ensure that the application and the database are configured for connection pooling and that it is set to an optimal value
- The database server should be configured for any hardware failure as well as any database failure, which means an appropriate high-availability solution should be in place. For example:
• For SQL Server: Clustering along with mirroring, log shipping, replication, always on, etc.
• For Oracle: RAC along with a standby database, replication, always on, etc.
- Test existing high-availability solution
- Clean up and archive old data
- Archive old data that isn’t being used. This helps reduce the time it takes to perform database maintenance activities, such as rebuilding and reorganizing indexes, and updating statistics. It also helps improve query performance
- Archived data may simply be imported to another database, backup file, etc.
- Ensure all recent, ongoing, and pending issues are resolved
- Extract and analyze the errors and issues that have occurred recently or are recurring in nature, including problems and incidents recently fixed
- Review recent changes to your database configuration, including changes made due to a problem or incident. These may include patch updates, application updates, structural changes, added schedules, modified file parameters, and other configurable items
- Establish freeze dates
- To avoid unseen risks, implement a code/configuration freeze date
- List challenges and risks involved with any unavoidable implementations
- Review any changes with respect to all points mentioned above
Want more detailed advice from a technical expert? Schedule a call to get the conversation started.