Holiday Readiness ... Databases

Posted on 2014-10-28
Medium Priority
Last Modified: 2014-11-18
Would like to hear from the gurus, what we should do or the checklist; to best prepare ourselves for this coming holiday season, our primary focus is databases; Oracle & Sql Server

Please do share your valuable experiences & guidelines too.

Thanks in advance
Question by:mkhandba
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 3
  • +3
LVL 23

Expert Comment

ID: 40408527
Stay hydrated.  Assign designated drivers if appropriate. Nothing special should be required for the systems.
LVL 23

Expert Comment

ID: 40408534
What do you anticipate?
LVL 66

Expert Comment

by:Jim Horn
ID: 40408592
Curiosity overwhlems me ... is there a question here, or is this a 'let's swap war stories' thread?

Not that there's anything wrong with war stories.   'No sh&t, there I was...'
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40408621
As far as databases go, they don't what a Holiday is so they don't care.

As far as administration:  It is just another day as well.

Now if you work for Amazon/Walmart or some other retailer, then you can expect a HUGE increase in traffic.  Then you might need to have more bodies on site during this period.
LVL 74

Expert Comment

ID: 40408828
As others indicated there aren't really any technical issues related to the holidays but you may have logistical problems/opportunities.

Many people take vacation around the holidays.  Do you have coverage or will everyone be gone for some period.  If there is no coverage - is that ok? If not, how will that be handled?

If you're in the northern areas you may have weather problems as well.  Iced wires causing power outages., snow and slippery roads causing accidents and people late or unable to come in at all.  
Again - not strictly an Oracle issue; but your database won't run if the server is without power and if your staff can't make it in, then what?

Even if your entire staff is fully available - are your partners?  Are the sysadmins available or are they on vacation/snowed in somwehere?   What about your customers or upstream providers?

Maybe the problem is in reverse.  If you support a manufacturing facility that has a scheduled down time  then are you paying a bunch of contractors to support a system that nobody will be using for that time?  If so, maybe rotate the staff or use shortened work days to save money.

On the other hand.  If your customers aren't going to be using the system - that can be great time to do patching, upgrades, installations, restructuring, etc. without having to worry about impacting the business.

Author Comment

ID: 40408893
Thanks, we are in the retail business and expecting a huge amount of traffic on to our servers/dbs and for this reason, would like to prepare ... as we are already going through, some extensive exercises and checklists too; what needs to be done/checked/verified/tested, before we hit Thanks Giving.

This is the only reason, came here too, eg.,
- storage: are we able to grow?
- fail over: if we'd failed over; can the server able to bear the load ... & etc.

Some thing on these lines, primarily from database perspective; Oracle & Sql Server only.

And please do update/reply ... only, if you have anything good to share, otherwise ... it's just wastage of time and kind of annoying too ... when reading your thoughts, why really people share these kind of garbage ... some one said correct:

"Garbage in ... Garbage out"

Thanks again ... for sharing "Good" only.

Accepted Solution

mkhandba earned 0 total points
ID: 40408903
LVL 74

Assisted Solution

sdstuber earned 1500 total points
ID: 40408982
also note, in addition to basic capacity planning - look for special runs.

Not only is retail entering prime shopping season, it's also end of year, so in addition to an increased level of the normal business (i.e. normal capacity planning) - you also have year-end tax preparations and other human resources issues like vacation. retirement and bonus payouts.  New year allocations,  many businesses will be doing next year's insurance signups now and for the next several weeks.

So, for your ramp up in the main retail business where you might simply do a simple estimation of 2x, 4x, 10x level of activity (transactions, sessions, processes, cursors, archive logs, etc.) you will also have these other processes that will run sporadically and aren't simply an extension of your normal execution profile - they are distinct operations that will cause spikes of activity that don't correspond to the rest of the retail actions.

Ideally you will have previous years to compare to, both for your estimation of retail factoring but also these special processes.  If not - you'll just have to guess what you'll need.

Expert Comment

ID: 40411621
May want to look at cloud computing or other means of flexing to your traffic as it increases.  Distributed databases can also help, and you will definitely want to ensure your databases are backed up periodically.
LVL 23

Expert Comment

ID: 40412105
Mark, it would be helpful as well to learn your role in the business -- IOW are you a decision maker, or even a decision influencer?  

As a technical expert, I'm also curious what precipitated the question.  Is there any history in past seasons of performance/storage problems?  Are there metrics and alerts in place to monitor your resource consumption?  There are tools and procedures available, to simulate a stress load, if you need  any forward-facing guesstimates.

Finally, the topic begs the year-round question about the adequacy of your Continuing Operations (coop) plan.  In the event of a catastrophic failure, what is in place to mitigate its cost?  How much financial risk are the owners/managers willing to absorb?

Author Closing Comment

ID: 40449360
the only & a bit comprehensive
LVL 74

Expert Comment

ID: 40449688
why the penalty grade?

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question