Home > Case Studies > SQL Server Consolidation Reduces Servers by 95%

SQL Server Consolidation Reduces Servers by 95%

This power and utility industry customer is responsible for keeping the lights on for millions of consumers. The customer had a disparate and growing SQL Server footprint which, over the years, had amassed over 100 SQL Servers with 1,200 databases and storage of 8TB.

Industry

Utilities

Technology

SQL Server

Employees

1,001-5,000

Challenge

The customer recognized the need for evaluation and consolidation of their SQL Server footprint, which consisted of a mix of physical and virtual servers. Their intention was to create a more manageable, sustainable, and cost-effective SQL Server infrastructure by consolidating disconnected SQL instances into centralized SQL Server deployments.

Upon completion, the customer would realize the following main benefits:

  • Significant reduction in the number of physical and virtual servers
  • Significant reduction in licensing and maintenance costs
  • Simplified and manageable SQL Server footprint

Solution

IncWorx inventoried and documented all SQL server instances and deployments throughout the organization. We collected and analyzed all SQL server usage and performance metrics as well as completed the discovery and analysis of all database-dependent applications. We developed the plan and worked closely with the customer to achieve the desired results.

Some highlights of plan execution include:

  • Identification and decommissioning of irrelevant/unused databases
  • Remediation of applications unable to be upgraded
  • Installation and configuration of development, integration, and production SQL Servers
  • Configuration of SQL Server Always-On availability groups for all 3 environments
  • Deployment of latest SQL Server cumulative updates and service packs
  • Implementation of security and configuration best practices
  • Documentation of SQL server configurations and standard build process

Result

Upon completion of their new SQL Server footprint, the customer realized a massive 95% reduction in SQL Servers, an 80% reduction in the number of SQL Server databases, and a 70% reduction in storage. In addition, the customer saved an estimated $350K in licensing and maintenance costs.

%

Reduction in SQL Servers

%

Reduction in SQL Databases

%

Reduction in Storage

Thousands of Dollars Saved

Conclusion

Over time, it is natural for a company to deploy new instances of SQL Server for various reasons, often in the interest of time or to avoid disruption of existing systems and applications. Fast forward several years and many companies find themselves in the exact same situation as our power and utility customer, with a SQL Server footprint that has become overly complex, inefficient and costly. By recognizing the issue and engaging with IncWorx, our customer was able to consolidate and optimize their SQL Server environments and hence realize the benefits of a more centralized, efficient and cost-effective SQL Server implementation.

Want to learn more?

This is just one of the many solutions IncWorx has delivered for our customers.

To learn more about this or other solutions we’ve delivered, please contact us today.

[wpforms id="1422"]
<div class="wpforms-container wpforms-container-full" id="wpforms-1422"><form id="wpforms-form-1422" class="wpforms-validate wpforms-form" data-formid="1422" method="post" enctype="multipart/form-data" action="/case-studies/sql-server-consolidation-utilities-company/page/2" data-token="65181dfbca9af42ad92c701b9142c24a"><noscript class="wpforms-error-noscript">Please enable JavaScript in your browser to complete this form.</noscript><div class="wpforms-field-container"><div id="wpforms-1422-field_0-container" class="wpforms-field wpforms-field-name" data-field-id="0"><label class="wpforms-field-label" for="wpforms-1422-field_0">Full Name <span class="wpforms-required-label">*</span></label><input type="text" id="wpforms-1422-field_0" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][0]" required></div><div id="wpforms-1422-field_1-container" class="wpforms-field wpforms-field-email" data-field-id="1"><label class="wpforms-field-label" for="wpforms-1422-field_1">Email <span class="wpforms-required-label">*</span></label><input type="email" id="wpforms-1422-field_1" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][1]" required></div><div id="wpforms-1422-field_3-container" class="wpforms-field wpforms-field-phone" data-field-id="3"><label class="wpforms-field-label" for="wpforms-1422-field_3">Phone <span class="wpforms-required-label">*</span></label><input type="tel" id="wpforms-1422-field_3" class="wpforms-field-large wpforms-field-required wpforms-masked-input" data-inputmask="&#039;mask&#039;: &#039;(999) 999-9999&#039;" data-rule-us-phone-field="true" name="wpforms[fields][3]" required></div><div id="wpforms-1422-field_2-container" class="wpforms-field wpforms-field-textarea" data-field-id="2"><label class="wpforms-field-label" for="wpforms-1422-field_2">How can we help you? <span class="wpforms-required-label">*</span></label><textarea id="wpforms-1422-field_2" class="wpforms-field-small wpforms-field-required" name="wpforms[fields][2]" required></textarea></div><div id="wpforms-1422-field_15-container" class="wpforms-field wpforms-field-html" data-field-id="15"><div id="wpforms-1422-field_15"><p style="padding-top: 10px; padding-bottom: 10px; font-family: 'Open Sans', sans-serif; font-size: 10px; color: #333333;">By clicking the button below, you are agreeing to our <span style="text-decoration: underline;"><span style="color: #000000;"><a style="color: #000000; text-decoration: underline;" href="https://www.incworx.com/privacy-policy">Privacy Policy</a></span></span>.</p></div></div><div id="wpforms-1422-field_7-container" class="wpforms-field wpforms-field-hidden" data-field-id="7"><input type="hidden" id="wpforms-1422-field_7" name="wpforms[fields][7]" value="SQL Server Consolidation Reduces Servers by 95%"></div><div id="wpforms-1422-field_9-container" class="wpforms-field wpforms-field-hidden" data-field-id="9"><input type="hidden" id="wpforms-1422-field_9" name="wpforms[fields][9]" value="100.27.44.5"></div><div id="wpforms-1422-field_10-container" class="wpforms-field wpforms-field-hidden" data-field-id="10"><input type="hidden" id="wpforms-1422-field_10" name="wpforms[fields][10]"></div></div><div class="wpforms-field wpforms-field-hp"><label for="wpforms-1422-field-hp" class="wpforms-field-label">Email</label><input type="text" name="wpforms[hp]" id="wpforms-1422-field-hp" class="wpforms-field-medium"></div><div class="wpforms-submit-container" ><input type="hidden" name="wpforms[id]" value="1422"><input type="hidden" name="wpforms[author]" value="2"><input type="hidden" name="wpforms[post_id]" value="6307"><button type="submit" name="wpforms[submit]" class="wpforms-submit " id="wpforms-submit-1422" value="wpforms-submit" aria-live="assertive" data-alt-text="Sending..." data-submit-text="Submit">Submit</button></div></form></div> <!-- .wpforms-container -->