This is a time suck. You could dial up IT but the last thing you need is to make a bunch of noise awith someone looking over your shoulder while you’re in this position. Besides, IT is working on downstream issues: ERP, MES, SCM, CRM, etc. This is an Engineering problem; the data and user interface are different: dimensions, form, fit, and function… Numbers! IT is thinking dollars, and transactions. Your problem is plumbing; IT is focused on fixtures.
So you’re stuck: sitting there with your system straining and your pants down around your ankles – not the best position from which to cry out for assistance, or worse yet… rescue. Oh, the ignominy! – waiting for something to happen.
Your Engineer mind completes its analysis of the application layer:
- Processes working? Change Management? Check-in/Check-out? Check.
- Collaboration happening? Replication functioning? File access available? Check.
So it’s not the application layer. You move to the data layer:
- When was the last time this happened?
Holy Crepes… That’s it! BINGO! Garbage in, Garbage out! The database hasn’t had a good cleanse for weeks! Months even! Years?! – Good LORD!! You smile at the revelation. Managing the Application Layer was a red herring. This problem is all about good old-fashioned database management. The genius solution is… a Data Dump!
There it is… EUREKA! System Clean-Up!
There’s GOLD in them thar hills! MOVEMENT!! Oh, that’s so much better! It’s all falling into place. When you turn your attentions to the data layer, out flow all the problems. There’s just nothing quite like a good ole solid purge! The clicks come rumbling out. You feel the rush of relief. It’s all you can do not to sigh out loud and laugh a little to yourself.
Man, it feels good to make things happen; to figure things out! You’re gonna have that next cup of coffee… and enjoy it!
Right… So… Now that you’ve got that out of your system, it’s time to get to work. Administer the flush commands and think about other performance improvements – like a systems approach so the next guy doesn’t have to deal with this…problem.
Oh, and leave the paper, because that’s the kind of Engineer you are.