07/03/2024

Adapt or Perish: Change Management

Business is the track we’re all riding on. It zigs, it zags, and just when you think you’ve got a straight shot, it throws you for a loop. From the ups brought by technological innovation to the subtle tremors of consumer preference, change keeps the wagon moving. Without it, our tale of commerce and industry would be as dull as a car ride to the nearest shop.

But here’s where it gets interesting. Businesses that treat change like an unwelcome guest at the party are the ones that end up sitting alone in the corner. The real movers and shakers are the ones who invite change to dance, anticipating its moves and stepping in time.

Why Changes Matter – The Importance of Change Management

Businesses, big or small, are in a perpetual game of tag with change management. Just when you think you’re “it,” change taps you on the shoulder and says, “Not so fast.” It may be a tech breakthrough that makes your hottest product look like yesterday’s potatoes or a sudden market shift leaving your sales strategy high and dry. Change doesn’t knock; it just goes for it.

The significance of keeping up cannot be overstated. Changes represent critical inflection points where businesses can either take advantage of new opportunities for growth and differentiation or risk gradual obsolescence.

Adaptability to properly deal with change management is what separates market leaders from the rest. It involves recognizing the winds of change early and adjusting sails accordingly. For example, a business observing a trend toward sustainability might pivot its product lines and operational practices to align with environmental values. That’s how they would capture a growing segment of eco-conscious consumers.

Companies have no real choice here. From social media and improving customer service with chatbots or CRM systems to automating production processes – Businesses have to react to changes, employ change management, and change themselves in order to strive. 

The Risk of Technological Advancements

Sometimes, the appeal of new technology can hide the risks of using it. As a wise man once said: “Anything that can go wrong will go wrong.”

The Minefield of Program Errors

While enjoying new solutions, one cannot forget about the risks arising from program defects that can lead to system failures, data loss, or malfunctioning business processes.

Imagine, for a moment, a scenario where a thing that seemed a minor software update triggers a cascade of system failures across your business. Suddenly, your digital infrastructure crumbles to dust. Data integrity is compromised, and the flow of operations you rely on is interrupted. The consequences? Lost revenue, eroded customer trust, and a tarnished brand reputation.

Operational Missteps

But it’s not just software glitches we need to be wary of. The human element—operational errors—can be as dangerous. Mistakes such as incorrect use of systems or failure of staff to manage them, can also lead to serious problems such as inadvertent disclosure of confidential information, misinterpretation of data or loss of operational efficiency.

Consider a well-intentioned employee who, lacking proper training, leaks sensitive customer data. The fallout from such a breach can range from legal repercussions to irreversible damage to customer relationships.

Addressing the Risk

As you can see, it’s critical for businesses to not only adopt new technology as soon as it’s possible but also ensure that staff are adequately trained in its use. Implementing proper procedures for preventing and responding to software errors is essential. Regular testing, performance monitoring, and quick responses to detected issues are key strategies for minimizing risks. This helps protect operations against potential losses and guarantees business continuity, even in unexpected situations. How to do it?

ITIL and Maturity Models for Effective Change Management

Integrating ITIL and maturity models into organizational practices offers a structured pathway for change management. These frameworks emphasize a systematic progression through defined stages of maturity, mirroring the structured progression found in educational systems. 

Indeed, maturity is quite a nice word for it. Just as an individual’s education evolves through stages—from preschool to higher education—so too does an organization’s process of maturity.

The ITIL framework is structured around five core stages:

  • Service Strategy: This stage focuses on designing, developing, and implementing service management as a strategic asset and assisting in the growth strategy of the organization.
  • Service Design: It involves the design of IT services, processes, and other aspects of service management to meet current and future business requirements.
  • Service Transition: This stage manages changes to the IT service environment, ensuring that changes are made with minimal impact on existing services.
  • Service Operation: It focuses on the effective and efficient delivery and support of services to ensure value for the customer and the service provider.
  • Continual Service Improvement: This final stage aims to create and maintain value for customers through better design, introduction, and operation of services.

DBPLUS PERFORMANCE MONITOR – OPTIMIZATION IN CONTEXT

DBPLUS PERFORMANCE MONITOR extends the ITIL theory. Aside from helping to navigate through the five stages of IT service management, it also integrates historical context into its analysis. This enables clients to accurately understand and analyze past events, allowing them to make informed decisions about their IT service management strategies. 

By considering the broader historical context, DBPLUS provides a better understanding of changes over time, facilitating a deeper insight into potential improvements or necessary adjustments.

The case

To demonstrate the effectiveness of DBPLUS Performance Monitor, let’s consider a client’s case where a new SQL query exhibited inconsistent execution times, sometimes fast, and sometimes slow, making it unpredictable.

1st Query: Identifying and Analyzing the Problem

  • Accessed the “SQL Details” page to input the specific query’s hash value.
  • Selected a 30-day period for a comprehensive data analysis.
  • Grouped the performance data by system snapshots taken every 15 minutes to observe the query’s behavior over time.
Change management -- 1st Query: Identifying and Analyzing the Problem

2nd Query: Visualizing the Issue

  • Switched to the “Graph” tab to compare different execution plans.
  • Noted the presence of gray columns indicating non-working days, during which the query was not executed.
  • Identified a “chimeric” initial plan and a subsequent optimized plan, highlighting the performance variability.
Change management -- 2nd Query: Visualizing the Issue

3rd Query: Pinpointing and Addressing the Cause

  • Used the “Explain Plan” tab to compare the slow and fast execution plans directly.
  • Noticed significant differences in the indexes used by the slow and fast queries, particularly in terms of “Cardinality” and “Columns.”
Change management - 3rd Query: Pinpointing and Addressing the Cause

 After creating an outline, the execution time became stable and faster, showcasing a significant improvement. This scenario was analyzed using DBPLUS’s tools. It focused on the query’s performance over the last 30 days and examining different execution plans. By comparing these plans, key differences were identified, particularly in indexes. They pinpointed the cause of the instability which led to optimizing the query’s performance.