<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=204641&amp;fmt=gif">

Database Consolidation

Posted by Andreas Hope on Jun 9, 2016 8:06:00 AM
Andreas Hope
Find me on:

In the last decade, companies around the world have adopted new database systems, to cope with the flood of new information in the enterprise. New applications have been introduced with little time for the IT organization to organize this correctly. The push from application vendors for their favorite database system, leaves the companies with many separate resources and oversized systems, both in terms of hardware and licensing. 

The sheer number of applications and vendor specific requests and recommendations had complicated the job of the DBA and the IT managers, who prefer a standardized configuration with the minimum number of different platforms, versions and licenses. In addition, many applications are suffering from poor performance as a result of code that is not optimized, where the temporary solution has been more hardware. 

This is one of the main reasons many companies today are struggling with an over-complex database environment and lacking an insight to their real needs. The result is that the daily operations of databases is demanding and unreliable, with a high cost related to licenses, tools and staff. 

Many IT managers are under a constant pressure to reduce costs for hardware, licenses and tools, whilst still providing a better service with a limited staff. But with a lack of in-depth knowledge and an understanding of their actual needs, they are forced to rely on vague advice from staff and vendors. This can lead to more questions than answers related to consolidation, license use, hardware requirements and possible optimizations.

  • Can we reduce the number of servers?
  • How much of our current resources are we using?
  • Are our databases running a healthy setup?
  • What are our actual license needs?
  • What systems can share resources?

Perhaps the most important question: "What is the cost in time and money for a reliable and optimum database environment?" 

To adequately answer these questions, you need to go through several steps where a competent DBA resource is essential. We have collected all these steps in an e-book, so that you can review them in your own time. 

Download the e-book or read about dbWatch here.